Let’s assume you have a chart that you want to highlight a particular value, in our case we have a plot of the variation in the modulus of elasticity of steel with respect to steel temperature (from NZS3404 standard), and we are interested in highlighting a data point which happens to be at 450 degrees centigrade. I’m guilty of adding a lot of series to charts to finesse the look, so one less (usually) unnamed series suits me. This takes a bit of a different path to setup to get the desired effect but it’s one less series you’re needing to generate data for on your sheet, and it keeps the clutter down in the chart Select Data Source window (if only you could resize this dialog box …… MICROSOFT!). These additional series for the lines are however quite redundant as you can achieve the same thing using the built-in error bars in Excel. I’m often guilty of adding some additional horizontal and/or vertical lines as another series to the X and Y axis to enable easier reading off the values of interest. Usually in these instances I’d plot another data series and add some markers to highlight these points. Hi all, In an XY scatter chart plotted using XL2007, I can select the series, and then by following Chart Tools > Layout > Error Bars > More. Any changes you make on the Patterns tab affects both X and Y error bars. In the chart below I have clicked once, which selects both X and Y error bars in an XY chart. If you have an Excel chart you might often have the need to highlight a certain value of interest. To format error bars, you first select them, then bring up the dialog with a double click, a right click, the Ctrl+1 shortcut, or the Format menu. This is a handy technique that I was recently reminded of, using error bars to highlight values on XY scatter charts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |