Graphing Subtotals

H

Henry

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
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal 1
Plotting Graph with dynamic table 3
Unmatched rows 0
Hide line and legend when data not present 0
Exclude Row in Sort 1
Overlay line graph points on bar graph 1
Automatic Macro to create 200 graphs 1
Pivot table chart problem, How to show different subtotal levels 2

Top