I am attempting to provide conditional formatting for a bubble graph in which the color of the bubble will bet set depending upon certain criteria. I wish to provide formatting without having to go down the VBA path.
<5 - Red
Between 5 and 10 - Yellow
>10 - Green
Use multiple series, one for each colour.
Use formula to populate each series with the correct values or NA() function.
Search forum for Conditional charts or post example if you need more help.
Many thanks for the reply. I am currently utilizing IF/NA() formulas for each of the colors. The problem I am dealing with is that the buckets and numbers are not static. The user will populate a wide range of potential numbers/percents.
Any thoughts??
Would need to see example of your data/formula/chart to understand what you mean.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks