Michael Kensy
New Member
- Joined
- Sep 27, 2017
- Messages
- 25
Hola
I am struggling with a Radar Chart to eliminate the line between datapoints in case some datapoints being empty.
A) I created a table referencing data from a Pivot Chart and added a Displayed Values Average and an Whole Data Average columns. Selecting that table as basis for Radar Chart causes lines for some datapoints zero as no value given. I found an advice to use a formula to replace empty values in an if formula with #NV but that didnt work for me. Neither could I put in If(...,#NV ,...) nor If(...,"#NV",...)
B) Creating a Radar Chart based on the Pivot Table itself creates a chart with gaps wherever there is a missing datapoint value but it does not allow me to add a data series for personal and over all average although at least the Displayed Values Average is part of the Pivot Table already
Does anyone have an idea, how I can get what I want?
--
Regards Michael
I am struggling with a Radar Chart to eliminate the line between datapoints in case some datapoints being empty.
A) I created a table referencing data from a Pivot Chart and added a Displayed Values Average and an Whole Data Average columns. Selecting that table as basis for Radar Chart causes lines for some datapoints zero as no value given. I found an advice to use a formula to replace empty values in an if formula with #NV but that didnt work for me. Neither could I put in If(...,#NV ,...) nor If(...,"#NV",...)
B) Creating a Radar Chart based on the Pivot Table itself creates a chart with gaps wherever there is a missing datapoint value but it does not allow me to add a data series for personal and over all average although at least the Displayed Values Average is part of the Pivot Table already
Does anyone have an idea, how I can get what I want?
--
Regards Michael
Last edited: