How do I change the data set on the X axis? (office 2003)

G

Guest

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
 
B

Bernard Liengme

Remove the text in the top cell over the x-values; now make the chart.
Excel thinks you have two data series
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Make Y-axis values correspond to x- axis value 1
How can I make a scatter plot graph with a category x-axis? 0
How do I put words as the Y axis values? 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Data labels along below x axis when y axis has negative values 1
Excel 2007: X-axis labeling 1
Negative values on X axis 6

Top