I want to make a graph with 6 series with 2 data points each.
The first points of each serie (on the left hand side of the graph
should be linked to a primary Y-as, the second points (on the right
should be linked on the secondary Y-as.
Is this possible?
Is it also possible to make this happen in VBA

--
Message posted from http://www.ExcelForum.com

Roland -

An entire series is associated with a single axis. But you can fake it.
One way is to make twice as many series, 1 through 6 primary and 1-6
secondary. The primary ones have the first data point and a zero; the
secondary ones have a zero and the second data point. Plot all 12, then
double click a secondary one and on the Axis tab, assign it to
Secondary. Select each additional secondary series and press the F4 key
to repeat. Format 1-secondary to look like 1-primary, and so on. Select
the legend, then select the text of a duplicate entry, and press Delete
(don't select the colored box, or you'll delete the series in addition
to the legend entry). Do this for the other 5 duplicates.

Another way is to add a fake axis, and scale the second point in each of
the six series by the ratio of the two axis maxima. For a fake axis
procedure, look at this page:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

roland willems < wrote:
> I want to make a graph with 6 series with 2 data points each.
> The first points of each serie (on the left hand side of the graph)
> should be linked to a primary Y-as, the second points (on the right)
> should be linked on the secondary Y-as.
> Is this possible?
> Is it also possible to make this happen in VBA ?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>