I have 3 columns, a date, stage, and score column.
Best way to present data is with a line and stacked column chart. I use
- date as the shared axis,
- the stage as the column values. I codify each stage to a value, 1-5
- I use the score as the line axis values.
I want to be able to identify each stage with a different colour, so add stage value to Column Series.
This is nice, but I lose the line values. Any suggestion to how I can have both options (line and coloured columns)
If possible, share a simplified example to reproduce this.