Forum Discussion
Line Graph with line for each week
This graph will be made up of 3 different data points: X-Axis, Y-Axis and Legend.
Based on what i see:
X-Axis is your Column names
Y-Axis is your Sum of Values
Legend is your Dates.
You immediate problem will be the column names. So my suggestion will be to go into Transform Data and do an Unpivot of your data. This should give you an 'Attribute' column which contains the column heading names, and then 2nd column which holds your values. Now you should be able to get that X-Axis working.
This graph will be made up of 3 different data points: X-Axis, Y-Axis and Legend.
Based on what i see:
X-Axis is your Column names
Y-Axis is your Sum of Values
Legend is your Dates.
You immediate problem will be the column names. So my suggestion will be to go into Transform Data and do an Unpivot of your data. This should give you an 'Attribute' column which contains the column heading names, and then 2nd column which holds your values. Now you should be able to get that X-Axis working.
Thank you so much, this has worked nicely to achieve what I was after.