Excel: Pivot tables with Line Graph with outside data
October 10, 2012 11:33 PM Subscribe
Excel Pivot Table + Line Chart Help
posted by MikeyObviously to Technology (3 answers total)
I have a worksheet of raw data that I'm pivoting into a new worksheet. For the column row I have DATE, for the value date I have REVENUE. And under filter I have TYPE.
Then after the pivot table, i'm copy/pasting two more columns of data from another source to create a calculated field.
I want to create a line graph that makes a line for each TYPE. currently, I can only do it by what I select in the filter, but I want a line for each TYPE.
I could do this with a lot of copy/pasting out of the pivot table, but is there a simpler way? And I can't use a Pivot Chart, as I have to utilize copy/pasted fields outside the pivot table.