I am trying to create a graph that would show revenue on the x axis and time spent on the Y axis and then the dots would grow in size based on revenue and I also want the color of the dot to change based on satisfaction level rating. Here is the some sample date
Customer Revenue time Hr satisfaction
Cust A 25000 10 5
Cust B 17500 5.5 3
Cust C 7000 8 2
Cust D 12000 9 4
The dot would be red if it was 1 or 2, Yellow if it was 3 and Green if it is 4 or 5.
While the native bubble chart may be like an X-Y scatter chart, you can make a pretty convincing fake using a line chart along with some VBA.
The suggested code traps changes to two named ranges: Revenue
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…