A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Comparative charts



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2004, 06:17 PM
Kelli
external usenet poster
 
Posts: n/a
Default 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  
Old October 27th, 2004, 02:08 AM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 09:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.