combined column graph

  • Thread starter Thread starter roland willems
  • Start date Start date
R

roland willems

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
 
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
 
Back
Top