Need 2 axis on a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart with 4 values evry month. The largest value goes to 370. One
item is a percentage between 99.9 and 100. I would like this to be the
fourth item and referenced to the right side axis, which would number from
99.9 to 100. When I assign it to the secondary axis, it jumps to the middle
of the month and hides the second value.

Can I get this set up to reference the right side axis?
 
In a column chart, the columns on a given axis are centered over the category. Hence
the single column on the secondary axis obscured the center column on the primary.

You can add dummy series, with zero values to be invisible, to maintain proper
spacing. You need one on the primary axis, after the first three series, to hold the
spot for the fourth visible series; you need three on the secondary axis before the
last series, to hold the spot for the three primary axis series.

The data would look like this:

PRI_1 PRI_2 PRI_3 pri_4 sec_1 sec_2 sec_3 SEC_4
Jan [data] [data] [data] zero zero zero zero [data]
Feb [data] [data] [data] zero zero zero zero [data]
Mar [data] [data] [data] zero zero zero zero [data]
Apr [data] [data] [data] zero zero zero zero [data]

The lower case headers refer to the hidden series. To hide them in the legend,
select the legend, then select the text of the legend entry (not the symbol), and
press Delete.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon, I kind of see what you are saying, it makes sense, and I am very
grateful. However, I don't see how I get the dummy values associated with an
axis. I have been right clicking the one I want to get it on the right axis,
but since the others do not have a value, I do not see how I do that.

Jon Peltier said:
In a column chart, the columns on a given axis are centered over the category. Hence
the single column on the secondary axis obscured the center column on the primary.

You can add dummy series, with zero values to be invisible, to maintain proper
spacing. You need one on the primary axis, after the first three series, to hold the
spot for the fourth visible series; you need three on the secondary axis before the
last series, to hold the spot for the three primary axis series.

The data would look like this:

PRI_1 PRI_2 PRI_3 pri_4 sec_1 sec_2 sec_3 SEC_4
Jan [data] [data] [data] zero zero zero zero [data]
Feb [data] [data] [data] zero zero zero zero [data]
Mar [data] [data] [data] zero zero zero zero [data]
Apr [data] [data] [data] zero zero zero zero [data]

The lower case headers refer to the hidden series. To hide them in the legend,
select the legend, then select the text of the legend entry (not the symbol), and
press Delete.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
I have a chart with 4 values evry month. The largest value goes to 370. One
item is a percentage between 99.9 and 100. I would like this to be the
fourth item and referenced to the right side axis, which would number from
99.9 to 100. When I assign it to the secondary axis, it jumps to the middle
of the month and hides the second value.

Can I get this set up to reference the right side axis?
Click to expand...
Click to expand...
 
Tony -

The dummy values have to be zero, not blank. Otherwise you can't select the series n
order to format it and assign an axis.

If it's any help, I've rewritten my Column Chart on Two Axes web page:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Jon, I kind of see what you are saying, it makes sense, and I am very
grateful. However, I don't see how I get the dummy values associated with an
axis. I have been right clicking the one I want to get it on the right axis,
but since the others do not have a value, I do not see how I do that.

:

In a column chart, the columns on a given axis are centered over the category. Hence
the single column on the secondary axis obscured the center column on the primary.

You can add dummy series, with zero values to be invisible, to maintain proper
spacing. You need one on the primary axis, after the first three series, to hold the
spot for the fourth visible series; you need three on the secondary axis before the
last series, to hold the spot for the three primary axis series.

The data would look like this:

PRI_1 PRI_2 PRI_3 pri_4 sec_1 sec_2 sec_3 SEC_4
Jan [data] [data] [data] zero zero zero zero [data]
Feb [data] [data] [data] zero zero zero zero [data]
Mar [data] [data] [data] zero zero zero zero [data]
Apr [data] [data] [data] zero zero zero zero [data]

The lower case headers refer to the hidden series. To hide them in the legend,
select the legend, then select the text of the legend entry (not the symbol), and
press Delete.

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

TonyMan wrote:

I have a chart with 4 values evry month. The largest value goes to 370. One
item is a percentage between 99.9 and 100. I would like this to be the
fourth item and referenced to the right side axis, which would number from
99.9 to 100. When I assign it to the secondary axis, it jumps to the middle
of the month and hides the second value.

Can I get this set up to reference the right side axis?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top