Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
473 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
The May 2025 update introduced the facility to format individual segments of a line chart.
The portion of the line from 2019 to 2021 has been formatted in a different colour.
However, if your data has too many data points, some will be missing from the format property due to a 60-category limit on the values it can display.
The line chart shows data all the way up to 2021 but the setting to format the line stops at 2009 due to the limit.
If you want to format sections of the line that don't appear in the list, you need to filter your data first.
Select the appropriate card in the Filters panel to filter your data and set the criteria needed to reduce the number of categories.
Setting the filter to be greater than 1990 will give enough free range to display categories up to 2021.
Expand the Lines property of the visual in the Format visual panel.
The items to format can be found in the Categories drop down.
Select the categories that you want to format.
Unfortunately, you have to format the categories one at a time.
Expand the Color property.
Select the colour you want for the chosen category.
Once you have finished formatting all the categories you need formatted, remove the filter you set from your visual.
The eraser icon is the quickest way to clear the filter.
You can learn more about this topic on the following Wise Owl courses:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2025. All Rights Reserved.