Group Data

[Melepoil]

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 ?
When I take all data grouped together (sales and collection) without
grouping them!!???

thanks

 

[Barb Reinhardt]

dO YOU WANT SOMETHING LIKE THIS?

http://support.microsoft.com/default.aspx?scid=kb;en-us;218153

(sorry about the caps)

 

[Jon Peltier]

Barb -

You must have transcribed some numbers. The article that came up is
"OFF2000: Error Message: 'Cannot Locate the Internet Server or Proxy
Server' When Clicking Hyperlink"

Perhaps the OP would like something along these lines:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______