The Y values (under “Labels”) are spaced above the line chart data points by the lengths of the error bars (under “Error Bar”).Ĭopy the first two columns of the data range shown above, select the chart, and use Paste Special to add the data as a new series.Īdd custom negative Y error bars using the values in the table (see Error Bars in Excel Charts or Error Bars in Excel 2007 for assistance). The dates are the same as the corresponding line chart data points. The data you need to label two points is shown below. Here is the line chart, unadorned by any labels. In Replacement for and Oil Price Radial Chart I used error bars as callouts, to connect labels to points on a line chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |