Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ant Ant is offline
external usenet poster
 
Posts: 53
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple graph formatting question for dates. LordJezo Excel Discussion (Misc queries) 1 July 21st 06 06:03 PM
graph problem - urgent help needed. harvey_nz Excel Discussion (Misc queries) 2 July 3rd 06 09:43 PM
Charting - 2 questions simple scale and use of F11 SteveW New Users to Excel 2 July 3rd 06 02:47 PM
Excluding Entire Data Fields in a Graph Steve D Charts and Charting in Excel 0 June 27th 06 09:35 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"