1) select B2:B11.
2) click chart wizard.
3) click the type of chart you want
4) click the "Series" tab
5) click the box next to the "Category (X) axis labels" and select
A2:A11
6) click Finish
Put a non-numeric label in B1, leave A1 blank, run the chart wizard.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
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.