Format chart series

dumutroba

Hello,
has anyone know how to format chat series so that the lowest is coloured in one colour and the highest in another
this is the task about the pivot tables
Also I don't know hoe they have got more than one series in the legend, I only get totals
any help much appreciated

haiyen90hn

Hello dumutroba, have you sorted it out? I am stuck at this exercise too and I'm going to sit an exam soon.

Pian32

Can I suggest you post the version you are using. Also look up what version will be in the exam. Excel tends to have similar tools between versions but can sometimes be in different locations or under different headers