Horizonal category axis
I want to take the years that are in cells B3-F3 and put them on the
horizontal axis. The directions say to edit the data source so that horizontal category axis uses the years in range B3:F3. Can someone help me? Thanks |
Horizonal category axis
Typically, when you are setting up the range to be charted, the top line, in
your case row 3, contains data for the horizontal axis, then the data follows in contiguous rows/cells, row 4 and below contain the data to be plotted. If your years are in a separate section of the worksheet it is likely not to work. If the data is not contiguous use the control key to highlight the sections. The highlighted sections must form a rectangle, e.i. line up. See the help section on creating charts. "formulaconfusion" wrote: I want to take the years that are in cells B3-F3 and put them on the horizontal axis. The directions say to edit the data source so that horizontal category axis uses the years in range B3:F3. Can someone help me? Thanks |
All times are GMT +1. The time now is 10:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com