de/selecting rows of data in a chart, 2007

  • Thread starter Thread starter MirandaD
  • Start date Start date
M

MirandaD

Say I have an array of data for a line chart, 10 columns and 20 rows, each
row is a country. I want an easy way to select whether the chart shows or
doesn't show a certain row (country) on my chart.
This was easy to do in ppt 2003. The only way I can figure out to do it in
ppt 2007 is to go to select data, add series, and then I have to define both
a series name and series values. Is there a way I can do it with one click,
e.g. just click on the country name (by clicking cell A5, if all the country
names are in column A) to select or deselect that entire row of data?
 
Turns out you can use filtering. Select the entire set of data, then filter.
When you select or deselect a country to include (a particular row of data),
it appears or disappears on the graph. Essentially just an easy way of
hiding/unhiding the rows (thanks Steve Rindsberg)
 
Back
Top