Excel secondary axis without layout tab

  • Thread starter Thread starter lcr2139
  • Start date Start date
  • Tags Tags
    Axis Excel
Click For Summary
To create a graph in Excel 2013 with two Y-axes, ensure that a chart is selected to access the "Layout" tab under the Chart Tools. If the tab is not visible, it may be due to the chart not being selected. To add a secondary axis, right-click on the data series, select "Format Data Series," and then choose "Secondary Axis" under Series Options. This method allows for effective visualization of data with differing scales on the same chart.
lcr2139
Messages
58
Reaction score
0
Hello, I am trying to make a graph on excel 2013 with two y axes, and the internet says I should click on the "Layout" tab under the Chart Tools tab, but I do not have that tab. How do I do this?
 
Computer science news on Phys.org
I am used to right-clicking the data series and then choosing Format Data Series | and clicking "Secondary Axis" under Series Options (at the top of the list).

As a side note: A Layout tab only appears when a chart is selected.
 
Thread 'ChatGPT Examples, Good and Bad'
I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...

Similar threads

  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 6 ·
Replies
6
Views
2K
Replies
21
Views
5K
Replies
9
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 9 ·
Replies
9
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 14 ·
Replies
14
Views
3K
  • · Replies 6 ·
Replies
6
Views
2K
Replies
3
Views
2K