Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple graph formatting question for dates. | Excel Discussion (Misc queries) | |||
graph problem - urgent help needed. | Excel Discussion (Misc queries) | |||
Charting - 2 questions simple scale and use of F11 | New Users to Excel | |||
Excluding Entire Data Fields in a Graph | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |