
Blanka Blair
Member
Members

Forum Posts: 53
Member Since:
October 17, 2015
October 17, 2015

I need to create a Year-on-Year chart where values are compared month by month.
For 2018 all the numbers are Actual, but for 2019 my Projected numbers change into Actual numbers as the year progresses.
I need to show different formatting for 2019 Actual vs. 2019 Projected numbers. I know how to change the formatting manually, but I need it to be dynamic. I know how to do it dynamically for a line chart (thanks to Mynda's Dashboard course), but I have no idea how to coerce the data layout to be able to do this for column chart.
Please, see attached file with some sample data and the charts explaining my problem.
Thank you.
Blanka

SunnyKow
Puchong, Malaysia
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Misael Gutierrez Sr., Bright Asamoah
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
David du Toit
Forum Stats:
Groups: 3
Forums: 24
Topics: 6358
Posts: 27805
Member Stats:
Guest Posters: 49
Members: 32335
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
