Re: OWC Chart: How to combine bar and line graf programatically?
From: Hans Riis (hri_at_bang-olufsen.dk)
Date: 05/04/04
- Next message: Kenneth: "IE crashes in owc11.dll when using Pivot Table"
- Previous message: Michael Vardinghus: "Re: Simple OWC10 licencing question"
- Next in thread: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Reply: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Messages sorted by: [ date ] [ thread ]
Date: 4 May 2004 14:34:07 -0700
Hi Alvin.
I understand what you're saying but how do I code it? As for colors I
just wish to set a colour for each series.
BTW, I don't know if it can be done programatically but it is possible
to have different axis scales in a combo chart. It's a bit tricky but
it can be done.
Regards, Hans Riis
"Alvin Bruney [MVP]" <vapor at steaming post office> wrote in message news:<e1iNb35KEHA.1416@TK2MSFTNGP09.phx.gbl>...
> the concept is the same, you would need two series instead of one. One
> series set to column, the other set to line. Colors you can set by using the
> interior object. It just depends on what exactly you want to color. Most of
> the UI objects contain an interior property which allows for coloring. You
> can color from borders, lines right down to invidual points. If you need
> different scales, you need to first ungroup the axes and then use the
> scaling object to customize the scales on the axes. One gotcha is, the axes
> cannot be customized for different scales on combo charts because it would
> distort the appearance for the series.
> hth
>
> --
> Regards,
> Alvin Bruney
- Next message: Kenneth: "IE crashes in owc11.dll when using Pivot Table"
- Previous message: Michael Vardinghus: "Re: Simple OWC10 licencing question"
- Next in thread: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Reply: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|