I have a pareto chart based on my actuals and I actually did not go into a dual access chart as I left out the bar chart piece. I do want to color it where the variance is less than zero however it is refusing to color.
What are the possible reasons for this and is there anyway to fix it?
and If I'm trying to bring two color legends into a dashboard is that possible.
You can definitely have two color legends in a dashboard. They possibly will need to be added separately for each sheet. To assist with the coloring issue it would be great to get a packaged workbook that was displaying the issue.
This can greatly assist community members in helping on questions!