Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Group Data
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 |
#2
|
|||
|
|||
dO YOU WANT SOMETHING LIKE THIS?
http://support.microsoft.com/default...b;en-us;218153 (sorry about the caps) wrote in message ups.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 ? When I take all data grouped together (sales and collection) without grouping them!!??? thanks |
#3
|
|||
|
|||
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/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Barb Reinhardt wrote: dO YOU WANT SOMETHING LIKE THIS? http://support.microsoft.com/default...b;en-us;218153 (sorry about the caps) wrote in message ups.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 ? When I take all data grouped together (sales and collection) without grouping them!!??? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to group a row so i can organise data by diff fields | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Computer freezes while using mouse to select group of data in Exce | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |