Graphing Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
outline an excel graph 1
Chart for hidden rows? 2
create hourly graph from half hour data 0
Data Subtotals Working Incorrecly 0
Pivot table chart problem, How to show different subtotal levels 2
Dynamic graph issue 2
Conditional SUBTOTAL in XL210 Table 7

Back
Top