Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Bar graph for capacity build-up in Excel

Posted by Andre Van Hoeck on September 26, 2001 2:01 PM
Hi,
I would like to build a bar graph showing the following:
x-axis y-axis
Capacity Price
0 to 100 35
101 to 200 55
201 to 500 75
etc...
How can I do this?
Thanks

If you intend the "x axis values" to be labels, then try this

Posted by Eric on September 27, 2001 9:04 AM
I may have missed what you are asking for, see if this is what you want
say your x axis values are in A2:A10 and your y axis values are in B2:B10. If my interpretation is correct and your "x axis values" are really "x axis labels", then try this:
select B2:B10, start the graph wizard, select "column" for the graph type, click "next", at the bottom of the "series" tab is an input box for "Category (x axis) labels". Click in that box and then select A2:A10, click "finish"
Is that what you are looking for?
BTW you can also select the entire column and then change the x axis range when you add more entries.
HTH


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.