View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Holger Gerths Holger Gerths is offline
external usenet poster
 
Posts: 29
Default Scattered chart combined with columns and time-x-axis in XL2007

Hmm, this is not a forward-step that XL2007 did here.
So we have to live here with two transparent charts stacked over each other.

Thanks, Holger.

"Jon Peltier" schrieb im Newsbeitrag
...
Ironically, the XY series can plot anywhere along a text axis in 2007. The
first category is at X=1, the second at X=2, etc. I hadn't noticed (or at
least I hadn't remembered) that the time scale axis didn't work this way.

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


"Holger Gerths" wrote in message
.. .
Dear Group,

until XL2003 I could create a column chart, configure the x-axis to as a
time-axis (for x-scaling purposes)
and I could place scattered charts (as carrier for text and symbols) at
any (non-integer) x-position.

Using XL2007, scattered charts can only be positioned on
x-integer-values.
So I am forced to put a second transparent scattered-chart over the
column-chart?
Or is there any better way to do this in ONE chart?

Thanks in advance: Holger.