LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Annie1904
 
Posts: n/a
Default Compare 1 yr's figures with another in a chart

How can I compare my 2005 and 2006 figures in a chart? I have 10 products,
which sales fluctuating year on year. I want to show differences between
sales ytd for 2006 compared to last year, 2005. I don't want my chart to
look too busy.

I suppose I'd like to have 10 bars, one for each product, each with a
shadow, the main bar relating to 2006 (current year) and the shadow relating
to 2005 (previous year). Can't find this anywhere.

But any other suggestion will be considered! Thanks.


 
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
compare small and large figures in one chart duha Charts and Charting in Excel 1 January 15th 06 07:52 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
How to compare current year to prior year in bar chart? substring Charts and Charting in Excel 4 May 12th 05 07:04 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 02:48 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"