Thread: Secondary axis.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Secondary axis.

Hi,

See here for information on the way around the problem.
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

Cheers
Andy

Sarah wrote:
I need to create a 2d bar graph with two different axis. I have used the
secondary axis in the format series option but can not get the bars to
display next to each other, they keep over lapping. In total i have 3 series
for each section, the bar on the secondary axis keeps overlapping between the
other two on the primary axis. Does anyone know how to stop this from
happening.

the primary axis is percentages and the secondary axis is a value.