Chart

Copper Contributor

Can you simply rotate a chart(X/Y) where the primary and secondary data would be on top and the primary axis is on the left?

3 Replies

You can simply do that.

 

Change the way that data is plotted

  1. Click anywhere in the chart that contains the data series that you want to plot on different axes.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  2. On the Design tab, in the Data group, click Switch Row/Column.

  

Excel Ribbon Image   

 

Source: https://goo.gl/QbbrFq

 

Thanks for the reply Hatham.  When I did that it told me I only had max of 255 data series per chart. 

Excel has a limitation that it doesn't allow you to display more than 255 series or data per chart.

 

To learn more about this, see:

https://goo.gl/EoETOs

https://goo.gl/1ukQmO