You need to set the x axis to be category rather than date.
Right click the chart and pick chart options. On the axis tab you can set
the axis type to category.
sorry, i should have been more clear, how do i do it in 07? i've been all
over the ribbon and can't find the chart options that 03 had, and right
clicking doesn't give it to me.
Sorry but I must be missing something. I'm with you until "Axis Options", but
under "Axis Options" I don't see anything that says "Axis Type" or anything
that gives me the option to have a text axis. Thanks
What kind of chart have you created? Is it an XY chart or a line chart? The
descriptions in this thread cover line charts only. If you are using Excel
2003 or earlier, see Andy's earlier post. Andy's latter post id for Excel
2007.
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.
