Forum Discussion

MiFi1's avatar
MiFi1
Copper Contributor
May 23, 2024

How can I get Excel to select correctly a chart series?

I get mad by trying to fromat my chart series correctly.

It consists of 2 series,  those of class 1 and the other ones of class 0.
When I select one bar from class 1 using "format data series", it just selects a weird mixture of values from class 1 and 0.
When I select one class from the data selection and then apply e.g. a colour change, this will also apply to the unselected class.
How can one do the job correctly?

P.S. the data comes from a pivot table, apparently that makes the difference.
I get the same weird behaviour from Office 2019 equally on Mac or Windows.

  • MiFi1 You neither show your data nor the way you set-up the chart, but I tried to recreate something based on the picture alone.

     

    You don't have two separate series for each class. There is one series of zeros and ones. That's why Excel selects all data points and assigned one colour to all columns.

     

    I suspect that you have the Class field in the Row area of the pivot table. Move it over to the Column area and you will get two series.

     

    See attached.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    MiFi1 You neither show your data nor the way you set-up the chart, but I tried to recreate something based on the picture alone.

     

    You don't have two separate series for each class. There is one series of zeros and ones. That's why Excel selects all data points and assigned one colour to all columns.

     

    I suspect that you have the Class field in the Row area of the pivot table. Move it over to the Column area and you will get two series.

     

    See attached.

    • MiFi1's avatar
      MiFi1
      Copper Contributor
      Thank you for the decisive hint.
      I finally got it it to show my graph as requested.
      The graphical shown selection of the series is still weird with columns missing in the data series selection, but I have noticed another context window above the main context window with format options by series.
      And formatting out of that context windows works.
      Regards.

Resources