Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to change position of chart labels on line chart | Charts and Charting in Excel | |||
how to remove dotted line with words chart area from around chart | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel |