Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
The "Total Sales" spreadsheet in my work book lists sales data for four
product lines over a 6 month period. The total in any of the cells B3 through E8 is the sum of the corresponding cells in the Domestic and International spreadsheets. I would like to represent the data in these cells as a bar chart and would like each vertical bar in the chart to visually represent the data from which it was summed. For example: the value of 40 in Total Sales cell B3 is made up of 27 from Domestic B3 and 13 from International B3. Is there a way to shade or crosshatch or otherwise indicate the components that make up each bar on my bar chart? I have a sample spreadsheet that I can upload if it would help to explain my question. Thanks in advance for any help. Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shade a cell | Excel Discussion (Misc queries) | |||
How do I shade only 1/2 of a cell? | Charts and Charting in Excel | |||
How to shade every third row? | Excel Discussion (Misc queries) | |||
shade rows | Excel Discussion (Misc queries) | |||
Shade Every Other Row | Excel Discussion (Misc queries) |