I am looking for help on creating a specific graph in Excel. I have a teacher who wants a bar graph with dates on the x axis and population growth on the y axis. However, every time I try to create this graph, the dates either show up as the numbers 1, 2, 3, 4 or 1900. Not 1960, 1970, 1980, as I have them entered into column A in the spreadsheet. Can anyone give me any ideas for how to fix this?
Thanks, but I had already tried that. It turns out that I would need to select column B and create the chart and then add column A in later when I needed to change the series. Thanks for replying and trying to help-I appreciate it!
struggled with this before and the only way I can do it is to choose an xy scatter
to associate each column with data then after graph is made right click
and change back to bar....seems weird but strangely logical give
all the known Excel bugs...hope that helps
Permalink Reply by Jodie on November 10, 2008 at 11:56am
I think you need a column chart not a bar if you have years in A and population in B and want dates on X and pop on y.
Anyway, the solution of dates not numbers is on the series tab of the step 2 of making a chart.
I have a power point slide with the steps broken down to this point. I think you know how to take it from there. If you need more help let me know. I hope this helps.