W
wamiller36
Challenge:
1. I have a fairly straight-forward Pivot table (3 levels of Row labels, 1
level of Column labels.)
2. I want to create a Chart of a specific (manually-selected) data from
within the Pivot table, that I select using the Control Key to get the series
labels and actual data.
3. When I F11 to create a chart, I get the WHOLE FREAKING pivot table's
worth of data in the chart, and not just what I wanted. Really screws up the
chart.
Can anyone give me some tips here? I don't want to do a copy/paste special
approach to get the data isolated, just so that I can create a chart.
Thanks, all.
wam
1. I have a fairly straight-forward Pivot table (3 levels of Row labels, 1
level of Column labels.)
2. I want to create a Chart of a specific (manually-selected) data from
within the Pivot table, that I select using the Control Key to get the series
labels and actual data.
3. When I F11 to create a chart, I get the WHOLE FREAKING pivot table's
worth of data in the chart, and not just what I wanted. Really screws up the
chart.
Can anyone give me some tips here? I don't want to do a copy/paste special
approach to get the data isolated, just so that I can create a chart.
Thanks, all.
wam