ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   chart x-axis values appear as a series (https://www.excelbanter.com/charts-charting-excel/151858-chart-x-axis-values-appear-series.html)

rm5417

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?

Jon Peltier

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