Forum Discussion
Help in creating a chart
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 :
- Y Axis - should show Green/Yellow/Red
- X Axis - should show the Sprint ID
- Instead of each Cell - have a dot, if possible at the same color as it represents
- Connect between the dots with a line
- Add trend line (optional)
Any help would be appreciated.
Thanks,
Gadi.
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
1 Reply
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