What is the challenge? |
I've created a calculated column that I would like to reference as the series for a bubble chart however, the calculated column values are not recognized as options in the series on my bubble chart. |
What is the impact? |
The bubble chart series only shows (blank) so I cannot use my calculated value as the series. |
Describe your idea |
I'm specifically looking at initiative due date to generate a Now/Next/Later value based on days until due. I would like to create a bubble chart that colors the bubbles using the Now/Next/Later value. |
Similarly, we have a product value score to calculate effort that is an average of Hardware, Software, Electrical and Mechanical Engineering effort. And value is a calculated number based on revenues. Since the current value/effort chart only allows one field on the X axis and one on the Y, I was able to recreate the formula as a calculated value in the list and transfer it over to the bubble chart, but unable to pull in the calculated value. It would be beneficial to be able to pull in the calculated values to utilize the chart.