#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default Chart


Hi All,


I have the following data


Office January 2005 February 2005 .....
sales Collection Sales Collection
A 1000 500 2000 2500
B 2000 1500 2500 1500

etc


How can I get a bar chart based on Month Sales/Collection comparison?
I get a chart of all data together (sales and collection) without
grouping each sales and collection toogether !!???

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Chart

Can you rearrange your data?...
A Sales A Coll B Sales B Coll
Jan 2030 750 3749 1000
Feb 4500 1850 7411 2000
Mar 4055 1554 5125 1500


Jim Cone
San Francisco, USA


"Soniya" wrote in message
oups.com...

Hi All,
I have the following data

Office January 2005 February 2005 .....
sales Collection Sales Collection
A 1000 500 2000 2500
B 2000 1500 2500 1500
etc

How can I get a bar chart based on Month Sales/Collection comparison?
I get a chart of all data together (sales and collection) without
grouping each sales and collection toogether !!???
Thanks

Reply
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
Macro to change position of chart labels on line chart Shane Henderson[_2_] Charts and Charting in Excel 1 May 27th 11 09:31 AM
how to remove dotted line with words chart area from around chart desof Charts and Charting in Excel 2 May 13th 09 10:18 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Excel 2003: How to nudge a chart element or shape on a chart? Ted M H Charts and Charting in Excel 5 June 30th 08 07:08 PM


All times are GMT +1. The time now is 10:41 AM.

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

About Us

"It's about Microsoft Excel"