I see that I can only create a pivotchart from a pivottable, but since the filtering options are on the chart, and the table is not important:
Is there a way to hide a pivottable If I only want to show the pivot chart?
Excel – only show pivotchart not pivot table
microsoft excelmicrosoft-excel-2010
Related Solutions
Ok, so it is possible to create a pivot table from a large text file directly (without first importing the text file). The following links outline how to do it...
Almost exactly my question: https://groups.google.com/forum/?fromgroups#!topic/microsoft.public.excel.datamap/zf0U-zSeypQ
Let's say this is our pivot table.
Now let's add our pivot chart - I've chosen a column chart for simplicity.
Copy your pivot table (cells A1:B10) and paste them elsewhere on the sheet - if you want the chart and the final table to be next to each other, lay them out accordingly now. I've pasted my second table into cell F1, and for clarity set it to be red.
Now in your original table, filter your row labels so that your pivot chart displays only the items you want.
Finally hide the original table (in this case I just hid columns A & B).
When you refresh the source data, both tables and the chart should all update. If for some reason they don't update, try using the Refresh All button on the ribbon.
Best Answer
A PivotChart and its associated PivotTable report must always be in the same workbook (as the Chart's data is based on the the table). However you can place the Chart on one worksheet and have the table on a separate one, effectively hiding the table from view.