Forum Discussion
How can I get Excel to select correctly a chart series?
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 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.
- 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.
