Thread: Chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
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