2nd Y axis

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
 
E

Earl Kiosterud

Anon,

Select the series that's to be on the 2nd axis. Format series. Axis tab.
Secondary axis.
 
A

Anon y mous

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!
 

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

Using text as data? 0
Bar graph and stacked bar graph on same graph 3
Grouped X-axis Categories 2
Column Chart 2
2nd Y Axis 3
Combination Chart 1
Bizarre chart behaviour when changing axis cross at points 2
Graph - Display Y axis data at top of chart(?) 5

Top