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

J

jrexattack

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

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
One extra x axis item that wont go away - can anyone help? 3
simple chart 0
Adding a line to a population bar chart 0
Excel 2007: X-axis labeling 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4

Top