Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating X & Y Mean Lines on Bubble Chart
I have a bubble chart that I would like to separate into 4 quadrants based on
the mean values of the X and Y data sets. I know I can do it using auto shape lines, but I would like to find a way that is a bit more precise and automatic. Any ideas? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating X & Y Mean Lines on Bubble Chart
Hi,
The bubble chart doesn't combine with any other chart type but you could add an extra data series and use the X & Y error bars to draw the lines. Cheers Andy Chris Turnbull wrote: I have a bubble chart that I would like to separate into 4 quadrants based on the mean values of the X and Y data sets. I know I can do it using auto shape lines, but I would like to find a way that is a bit more precise and automatic. Any ideas? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
customizing the mouse-over display in a bubble chart | Charts and Charting in Excel | |||
Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) | |||
Leader Lines Connecting Chart to Box | Charts and Charting in Excel | |||
ho to change in the bubble chart the bubble position and size | Charts and Charting in Excel |