Help in creating a chart

[gadi]

Hi,

I have this table which indicates the scoring for a sprint :

Sprint ID	Score	Score ID
1	Green	1
2	Red	3
3	Yellow	2
4	Red	1
5	Red	1
6	Red	1

Note that Score ID represets 1:1 value for the Color (Red = 3, Yellow = 2, Green = 1)

And would like to create a line chart as following:

With the following :

1. Y Axis - should show Green/Yellow/Red
2. X Axis  - should show the Sprint ID
3. Instead of each Cell - have a dot, if possible at the same color as it represents
4. Connect between the dots with a line
5. Add trend line (optional)

Any help would be appreciated.

Thanks,

Gadi.

[timg · Accepted solution]

Hi Gadi,

If a barchart would do the trick as well you could try this. Add a column with a colour hex code. create the visual. Then at the formatting pane of the visual  open the data colour section and press the fx button. Then select "fieldvalue" as the conditional formatting rule and select the colour hex column.

Regards,

Tim