2nd vertical axis

  • Thread starter Thread starter Ben Hammond
  • Start date Start date
B

Ben Hammond

I have read the thread on adding a second axis for one of
my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series together
into 1 bar (with 2 different colors). What I want is for
each category axis unit, TWO bars, each a different color,
and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben
 
Ben, you need to make the second data series a point plot
instead of a line. this way, it'll place the points over
top of the lines.
 
I'm looking for the same thing as Ben, but I want the data
in both primary & secondary data series to appear in
column format. In other words, the data sets should both
appear in column format, but relating to 2 different
axes. When I change the secondary axis to column format,
it overlaps the primary data and the other data set
becomes hidden behind the column? How can you shift the
second data series over so they appear next to each other?
 
Back
Top