Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
137
Views
Topic starter
How can we generate conditional formatting in Pivot Chart Dashboard?
I have my data of process parameter with the specification. So I created the line charts for data and specification.
How can I show if any of data point went beyond spec in different color?
Posted : 16/06/2020 7:17 am
Hi Zaki,
You can't conditionally format a chart. You'd need to create another series for data points that go beyond a certain value and plot those. However with a pivot chart you can't add a series that isn't from a pivot table, so you may need to use an ordinary chart.
If you post your workbook I can have a look at possible solutions.
regards
Phil
Posted : 16/06/2020 6:46 pm