![]() |
chart x-axis values appear as a series
The x-axis values do not appear on the x-axis but appear as another series on
the chart. How do I specify the x-axis values for a chart? |
chart x-axis values appear as a series
Existing chart:
Chart menu Source Data Series tab. For a new chart, fix the data first. Put the X values in the first column and Y values in the columns to the right. Put a label (series name) in the row above the first row of data for each set of Y values, but keep the cell atop the X values blank. Select the entire range, including X values, series names, and blank cell, then start the chart wizard. The blank cell helps Excel interpret the data range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rm5417" wrote in message ... The x-axis values do not appear on the x-axis but appear as another series on the chart. How do I specify the x-axis values for a chart? |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com