Forum Discussion
Saloni
Helper I
Helper IHow to filter area charts
I want to create an area chart for monthly data of 3 years. I have a list of 10 companies. How can I filter the companies I want to see on the chart? X-axis contains months and Y-axix contains the va...
A quick way to achive this is to use the Unpivot feature in the Query Editor.
So before :
After :
SaloniHelper I
Helper I
Data looks something like this. How can I apply a filter to the companies I want to see in the area chart?
Phil_Seamark
Microsoft Employee
Microsoft EmployeeI'd suggest pivoting your data so it's more in this format
Date , Company , Value 2/29/12 , A , 1 2/29/12 , B , 1.1 2/29/12 , C , 1.2 2/29/12 , D , 1.1 2/29/12 , E , 1.1 2/30/12 , A , 2 etc...
- Phil_Seamark
A quick way to achive this is to use the Unpivot feature in the Query Editor.
So before :
After :