ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I change the data set on the X axis? (office 2003) (https://www.excelbanter.com/charts-charting-excel/162567-how-do-i-change-data-set-x-axis-office-2003-a.html)

jrexattack

How do I change the data set on the X axis? (office 2003)
 
OK, so I created a frequency histogram (bar chart) by selecting the values
for the Y-axis, but I can't figure out how to change the values on the X-axis
to fit the rest of my values....


When I make the graph using both sets of data, it gives me two separate bar
charts on the same plane.

Help please :)
Thanks

Bernard Liengme

How do I change the data set on the X axis? (office 2003)
 
Remove the text in the top cell over the x-values; now make the chart.
Excel thinks you have two data series
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jrexattack" wrote in message
...
OK, so I created a frequency histogram (bar chart) by selecting the values
for the Y-axis, but I can't figure out how to change the values on the
X-axis
to fit the rest of my values....


When I make the graph using both sets of data, it gives me two separate
bar
charts on the same plane.

Help please :)
Thanks





All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com