Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Transposing data for line chart?

Hi All,   I want to make a line chart from the following data: I want Dates on the X Axis and then number values (for each colour) on the Y Axis.  Then I want the line values to be Ebitda YT...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

It is suggested to unpivot the color columns.

Select the color columns and then click 'Unpivot Columns'.

Then create a line chart as follows.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for this.
Do you know the best way I could work with this data.  Or anywhere I can read more to understand this. I'm finding it difficult to work with data with 3 main parameters 'Metric' 'Date' & 'Color'.  For example I may want to look at some (not all) of the metrics by date and filter by color.  It seems as if I have to sacrifice one and work with 2 of the 3.