If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bubble chart question
I suspect not many of you are using bubble charts, but I am trying to verify
whether I have a problem or if Excel does. Excel 2007 bubble chart using the following data: X Y Size -16 -4 5 -13 -15 2 -8 0 3.5 -4 -19 3 -2 -10 4 0 -4 3 0 14 3.5 8 -19 4 9 5 2 11.5 -5 4 The X-axis data does not plot the negative values correctly, they are all on the positive side. It appears that this feature preforms the same way in 2003. I realize that I can plot this using other chart types, but.... Any comments would be appreciated. -- If this helps, please click the Yes button. Cheers, Shane Devenshire |
#2
|
|||
|
|||
Bubble chart question
Hi Shane,
That data set produced a bubble chart with positive and negative values. Is it possible the x values are being treated as text. The layout of bubbles is very similar when treated as text. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Shane Devenshire" wrote in message ... I suspect not many of you are using bubble charts, but I am trying to verify whether I have a problem or if Excel does. Excel 2007 bubble chart using the following data: X Y Size -16 -4 5 -13 -15 2 -8 0 3.5 -4 -19 3 -2 -10 4 0 -4 3 0 14 3.5 8 -19 4 9 5 2 11.5 -5 4 The X-axis data does not plot the negative values correctly, they are all on the positive side. It appears that this feature preforms the same way in 2003. I realize that I can plot this using other chart types, but.... Any comments would be appreciated. -- If this helps, please click the Yes button. Cheers, Shane Devenshire |
#3
|
|||
|
|||
Bubble chart question
Hi Shane,
The first time I tried the chart was created as you described with the negatives on the right side. However as Andy said that was caused because the x axis was interpreted as text. Make sure the first row where the titles are is not included in your chart. Gustavo. "Andy Pope" wrote: Hi Shane, That data set produced a bubble chart with positive and negative values. Is it possible the x values are being treated as text. The layout of bubbles is very similar when treated as text. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Shane Devenshire" wrote in message ... I suspect not many of you are using bubble charts, but I am trying to verify whether I have a problem or if Excel does. Excel 2007 bubble chart using the following data: X Y Size -16 -4 5 -13 -15 2 -8 0 3.5 -4 -19 3 -2 -10 4 0 -4 3 0 14 3.5 8 -19 4 9 5 2 11.5 -5 4 The X-axis data does not plot the negative values correctly, they are all on the positive side. It appears that this feature preforms the same way in 2003. I realize that I can plot this using other chart types, but.... Any comments would be appreciated. -- If this helps, please click the Yes button. Cheers, Shane Devenshire |
#4
|
|||
|
|||
Bubble chart question
Well I'll be darned - I had included the title at the top of the column and
that made it intrerpret it as text. I really don't use bubbles so I didn't know about this feature(?). Thank both of you. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Andy Pope" wrote: Hi Shane, That data set produced a bubble chart with positive and negative values. Is it possible the x values are being treated as text. The layout of bubbles is very similar when treated as text. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Shane Devenshire" wrote in message ... I suspect not many of you are using bubble charts, but I am trying to verify whether I have a problem or if Excel does. Excel 2007 bubble chart using the following data: X Y Size -16 -4 5 -13 -15 2 -8 0 3.5 -4 -19 3 -2 -10 4 0 -4 3 0 14 3.5 8 -19 4 9 5 2 11.5 -5 4 The X-axis data does not plot the negative values correctly, they are all on the positive side. It appears that this feature preforms the same way in 2003. I realize that I can plot this using other chart types, but.... Any comments would be appreciated. -- If this helps, please click the Yes button. Cheers, Shane Devenshire |
Thread Tools | |
Display Modes | |
|
|