hello,
i have used external data to create pivot charts with ARs that are open, closed and pending.
when the chart is created the open is coloured RED, closed is BLUE and pending is GREEN.
But on one chart for a different area, i have no pending ARs.. and the open is now coloured BLUE and pending is coloured RED.
is there any way i can maintain the same colours throughout diff graphs??
i have used external data to create pivot charts with ARs that are open, closed and pending.
when the chart is created the open is coloured RED, closed is BLUE and pending is GREEN.
But on one chart for a different area, i have no pending ARs.. and the open is now coloured BLUE and pending is coloured RED.
is there any way i can maintain the same colours throughout diff graphs??
