I am trying to plot data in a scatter chart, and color code based on a value that is not plotted in the chart. For example, I have the following data - %Market Share, %Expense and Revenue:
Client A 25.6% 9.0% 30,888
Client B 33.6% 6.0% 67,812
Client C 18.1% 7.5% 68,194
Client D 20.9% 6.7% 40,758
Client E 11.1% 3.8% 13,154
Client F 33.9% 3.3% 51,240
Client G 18.8% 8.7% 28,098
I want the scatter plot to plot %Market Share and %Expense, but I want it color-coded by revenue, such that clients with revenue 0-30,000 are red, 30,000-50,000 are yellow, and 50,000+ are green.
Is there any way to do this? Is VBA the only answer?
Thanks!
Client A 25.6% 9.0% 30,888
Client B 33.6% 6.0% 67,812
Client C 18.1% 7.5% 68,194
Client D 20.9% 6.7% 40,758
Client E 11.1% 3.8% 13,154
Client F 33.9% 3.3% 51,240
Client G 18.8% 8.7% 28,098
I want the scatter plot to plot %Market Share and %Expense, but I want it color-coded by revenue, such that clients with revenue 0-30,000 are red, 30,000-50,000 are yellow, and 50,000+ are green.
Is there any way to do this? Is VBA the only answer?
Thanks!