Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Randy
 
Posts: n/a
Default Can I use the autofilter feature to limit data for a pivot chart?

I have a spreadsheet that I need to use the auto filter feature to display a
particular subset of data. I then want to create a pivot chart with the
limited data, but using different column and rows than the one filtered.
Whenever I try this, my pivot chart picks up the entire spreadsheet contents,
not just the filtered data.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Data Information to a Chart Mike M Charts and Charting in Excel 4 December 17th 05 12:12 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"