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 |