2nd Y axis

  • Thread starter Thread starter Anon y mous
  • Start date Start date
A

Anon y mous

There was a reply many months ago on how to essentially create a second y
axis by dragging and dropping. I cannot seem to re-create this anymore,
regardless of graph type.

I had a stacked bar chart and tried to do this, but it only added another
stacked bar onto the graph. I wanted a line on the second y axis.

i tried changing the chart type to a 2 axis chart, but went from stacked
bars to side-by-side bars...

Anyone have any suggestions?

TIA
 
Anon,

Select the series that's to be on the 2nd axis. Format series. Axis tab.
Secondary axis.
 
Thanks. That works for some means- I will try a little harder for the
stacked bar- it seems to mess up what I am trying to do.
Thanks!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar graph and stacked bar graph on same graph 3
Using text as data? 0
2nd Y Axis 3
Combination Chart 1
Excel chart does not start at zero. 1
graphs 1
Grouped X-axis Categories 2
Column Chart 2

Back
Top