Format chart series

dumutroba AAT Student, AATQB Posts: 264
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
AAT Level 2. 2018 Distinction
AAT Level 3. 2018 Distinction
AAT Level 4. 2019 FSLC 100% MABU 93% MADC 82% PDSY 80%
Xero Certified Advisor


  • haiyen90hn
    haiyen90hn Registered, AAT Student Posts: 6
    Hello dumutroba, have you sorted it out? I am stuck at this exercise too and I'm going to sit an exam soon. :'(
  • Pian32
    Pian32 MAAT Posts: 471
    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
    AAT Level 4, MAAT
    ACCA in progress
    F4- Passed Aug 2020
    F5- Passed Dec 2020
    F6- Passed Sep 2020
    F7- Passed June 2021
    F8 - Passed Sep 2021
    F9 - Passed June 2021

    ATX - Planned Dec 21
    APM -
Privacy Policy