I have a bar chart that shows percentages of work completed for each process undertaken, these processes then have a ragging to show where they are to target.
so above 85% is green
between 85% - 80% is amber
and below 80% is red
I was wondering if there is any vb code or a way of automating the chart so that the colours of the bars change when the percentage moves between the target.
Is this possible.
Thanking in advance of your help.
Usual way is to chart multiple series based on conditional formula. Each series is coloured to reflect the RAG.
Search for Conditional charts
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks