Graph in Excel

Replies to This Discussion

Permalink Reply by Erich Stephen on November 8, 2008 at 6:51pm

format the cell and change it to text instead of number

• ▶ Reply

Permalink Reply by Darcie Priester on November 10, 2008 at 5:52am

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!

• ▶ Reply

Permalink Reply by woody aunan on November 10, 2008 at 7:43am

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

• ▶ Reply

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.

Attachments:

• population chart.ppt, 395 KB

• ▶ Reply

Permalink Reply by woody aunan on November 10, 2008 at 7:00pm

darcie, jodie

attached is I what understood
hope it helps
if not let me know

Attachments:

• darcie.xls, 14 KB

• ▶ Reply

Permalink Reply by Darcie Priester on November 13, 2008 at 9:37am

Thanks everyone! I had a friend who figured it out for me and we were able to use it in class!

• ▶ Reply

Permalink Reply by Ted Lawrence on November 13, 2008 at 10:37am

I think this is what you need to do.

first convert the numbers in col A into text
then set your graph range to the values in col B
then set your x axis to the text in col A

Example is attached

Let me know if this helps

Attachments:

• Book1.xls, 14 KB

• ▶ Reply