Simple graph
I have a range of data corresponding to several years:
Year Amount 1997 100 1998 150 1999 200 2000 250 etc How can I display a graph with this range that shows the amounts in a bar graph on the Y axis and the years along the bottom on the X axis. If I use the wizard it tries to compare 1997 to 100 which is obviously not what I want to do. |
Simple graph
Hi,
The quickest way is to clear the cell that contains the word Year and then use the wizard. Excel is trying to help you, although not successfully, by using the column headers as a clue that you have two data series. Cheers Andy Ant wrote: I have a range of data corresponding to several years: Year Amount 1997 100 1998 150 1999 200 2000 250 etc How can I display a graph with this range that shows the amounts in a bar graph on the Y axis and the years along the bottom on the X axis. If I use the wizard it tries to compare 1997 to 100 which is obviously not what I want to do. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com