View Single Post
  #4   Report Post  
Tushar Mehta
 
Posts: n/a
Default

And, you figured I reached my conclusion by just pulling it out of a
hat? {grin}

I just rechecked XL2003:
1-Jan 10 20
2-Jan 12 40
3-Jan 15 30

XL creates 2 series in a bubble chart. The y-axis are dates! The
legend shows two series plotted. Series 1 has self-created x-values,
the dates as the y values and 10,12,15 as the bubble sizes. Series two
is invisible and cannot be seen. After deleting series 1, the arrow
keys will located series 2. Its y-values are 20,40,30 and its bubble
sizes are {0,0,0}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
In a quick test in Excel 2003 (then duplicated in Excel 2000), Excel by
default did use the dates as the X axis variable. The chart tip says

Series "y" Point "8/1/2005"
(8/1/2005, 50) Size: 0.625

If the "dates" in the first column of the data range are treated by
Excel as categories (i.e., valueless text), then you'd see the behavior
described by lupocattivo. What's funny, is that Excel sees them
formatted as dates, so my numbers 1, 2, 3 for the categories are
displayed as 1/1/1900, 1/2/1900, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Tushar Mehta wrote:

Interesting. If the first column is Dates XL doesn't put it on the x-
axis -- at least not by default. What you can do is in the 2nd step of
the chart wizard, click on the Series tab and adjust the X- Y- and Size
fields. XL may actually create an incorrect 2nd series with the bubble
sizes as the y-values of this series. If so, delete it.