![]() ![]() 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. The direction of the error bars depends on the chart. I’m guilty of adding a lot of series to charts to finesse the look, so one less (usually) unnamed series suits me. For xy (scatter) and bubble charts, you can display error bars for the x values, the y values, or both. Click the + button on the right side of the chart, click the arrow next to Error Bars and then click More Options. 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!). Without making any changes to the axes configuration, the second X-axis will now appear along the bottom of the chart, and you can see it is scaled differently from your Scatter data. 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. You can verify this by selecting Chart > Layout > Axes > Secondary Horizontal Axis > More Secondary Horizontal Axis Options. 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. If you have an Excel chart you might often have the need to highlight a certain value of interest. 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |