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

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