I have an Excel worksheet with data.
I want a resulting interactive 2D column chart that conditionally formats the column color based on some pre-defined reference values.
The Worksheet has rows with a description. The columns have values of each description from different dates.
The values in the columns have reference ranges.
· If <x, the="" value="" should="" be="" conditionally="" formatted="" to="" color="" yellow.="" <="" span=""></x,>
· If >X but <y, conditionally="" formatted="" to="" green.<="" span=""></y,>
· If >Y, conditionally formatted to red.
However, I don’t care what the color values are in data cells.
The column chart result I want should be conditionally formatted based on the values.
There is a workaround shown on this link:
Displaying conditional colors in a column chart
There is an interactive chart shown on Youtube using numbers:
https://www.youtube.com/watch?v=Gm0K8Y3JIVI
Around time 50 seconds, the Numbers chart on the right has interactive chart drop down menu with options for Slider and Buttons or Slider button only to customize the way to “play” it based on time values shown .
I need a How can I do both in Excel? Can someone help me write the macros or VBA code?
I want a resulting interactive 2D column chart that conditionally formats the column color based on some pre-defined reference values.
The Worksheet has rows with a description. The columns have values of each description from different dates.
The values in the columns have reference ranges.
· If <x, the="" value="" should="" be="" conditionally="" formatted="" to="" color="" yellow.="" <="" span=""></x,>
· If >X but <y, conditionally="" formatted="" to="" green.<="" span=""></y,>
· If >Y, conditionally formatted to red.
However, I don’t care what the color values are in data cells.
The column chart result I want should be conditionally formatted based on the values.
There is a workaround shown on this link:
Displaying conditional colors in a column chart
There is an interactive chart shown on Youtube using numbers:
https://www.youtube.com/watch?v=Gm0K8Y3JIVI
Around time 50 seconds, the Numbers chart on the right has interactive chart drop down menu with options for Slider and Buttons or Slider button only to customize the way to “play” it based on time values shown .
I need a How can I do both in Excel? Can someone help me write the macros or VBA code?
