Home For AAT student members AQ 2016 Advanced Diploma in Accounting Spreadsheets for Accounting
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Format chart series

dumutrobadumutroba 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


  • haiyen90hnhaiyen90hn Registered, AAT Student Posts: 4
    Hello dumutroba, have you sorted it out? I am stuck at this exercise too and I'm going to sit an exam soon. :'(
  • Pian32Pian32 Registered Posts: 144
    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
Sign In or Register to comment.