If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Comparative charts
I want to do a simple bar chart showing sales for each day this year, with
right next to it, sales from the same day last year. How would I setup my table to do this? I am dumping data from another source. THANKS! Kelli |
#2
|
|||
|
|||
Set up your data with days down column A, with the years as headings in
row 1. For example: 2004 2005 1 100 125 2 125 132 Select a cell in the table, and use the Chart Wizard to create a chart. Jon Peltier has a Charting tutorial that may help you: http://www.peltiertech.com/Excel/ChartsHowTo/index.html Kelli wrote: I want to do a simple bar chart showing sales for each day this year, with right next to it, sales from the same day last year. How would I setup my table to do this? I am dumping data from another source. THANKS! Kelli -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why did Pivot table charts copied into workbook with standard cha. | TamaJo | Charts and Charting | 1 | October 26th, 2004 01:53 AM |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 02:16 AM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |