Forum Discussion
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...
Anonymous can you please share the data in the text format which can be copied.
Metric Date Blue Red Green Orange Rev YTD Actual 28-Feb-22 100.00 1793.00 100.00 1822.00 Rev YTD Budget 28-Feb-22 1279.00 1670.00 1279.00 1670.00 Rev YTD PY 28-Feb-22 1237.00 15.00 1237.00 5400.00 EBITDA YTD Actual 28-Feb-22 1256.00 50746.00 1256.00 55495.00 EBITDA YTD Budget 28-Feb-22 1267.00 101091.00 1267.00 97685.00 EBITDA YTD PY 28-Feb-22 1657.00 2025.00 1657.00 30204.00 Costs YTD vs Budget 28-Feb-22 1987.00 1111.00 1987.00 -4.00 Bonus Retention Collection % (7 Mar) 28-Feb-22 1778.00 1700.00 1778.00 0.22 Rev YTD Actual 31-Mar-22 2513.00 1800.00 2513.00 2360.00 Rev YTD Budget 31-Mar-22 1831.00 1442.00 1831.00 3160.00 Rev YTD PY 31-Mar-22 2000.00 1235.00 2000.00 2180.00