Its a slightly complicated chart, with several data sources represented in different types on different axes.My problem is this: I want to add another couple of months to my chart.
How Do I Edit The Horizontal Axis In Excel 2016 Series On TheI r-clicked on the chart, selected Data Sources and went through each of my data series on the left side of this window to extend the range by a couple of cells.
I then used the section on the right to expand my selection of labels and, although the updated data is reflected in this window, its not reflected on the chart. PNG cap2.PNG cap3.PNG The chart previously went up to Aug, and as you can see from the screenshots, I have now added Sep and Oct to this. The chart extends, the data displays correctly, the Data Source window shows the correct range that I wish to use for my axis label, but then its blank on the chart itself Its driving me nuts If I edit one of the month names at the source, it is reflected in the chart. I just dont know why the two new values are not displaying on the chart, especially since they are displaying in the Data Sources window. If I try and add that now, it just puts the quarter name under the first month of each quarter. Eg, it does this. Cap1.PNG Instead of this. How Do I Edit The Horizontal Axis In Excel 2016 How To Fix ThatPNG Any idea how to fix that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |