| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graphing Subtotals
I have an Excel sheet with many rows with subtotals in between.
I wish to graph the subtotals without including the data that created the subtotals. I have been unable to exclude the underlying data from the graph. I wish the graph to show the subtotals only. Help please, Henry |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Graphing Subtotals
If I understand your problem correctly, when selecting the range for the
chart, first select the titles and then hold the Ctrl key down while selecting the data series. If you have more than one data series then continue to hold the Ctrl key and select the next data series. Regards, OssieMac "Henry" wrote: I have an Excel sheet with many rows with subtotals in between. I wish to graph the subtotals without including the data that created the subtotals. I have been unable to exclude the underlying data from the graph. I wish the graph to show the subtotals only. Help please, Henry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Hybrid Mode
