Forum Discussion

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 31, 2017

    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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 31, 2017

    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

     

    • Kelly Stanford's avatar
      Kelly Stanford
      Copper Contributor
      Mar 31, 2017

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