G
Guest
I need help creating a line graph that will have multiple background colors.
The basic purpose of this is to be able to look at a line graph and see how
the performance metric is doing based upon which color background the line is
sitting on. I need to have 5 colors that have scales that need to be able to
change dynamically. Is there a way to do this in Excel? I know how to change
the entire background to 1 color, but need to be able to partition off
sections of the graph into different colors.
The basic purpose of this is to be able to look at a line graph and see how
the performance metric is doing based upon which color background the line is
sitting on. I need to have 5 colors that have scales that need to be able to
change dynamically. Is there a way to do this in Excel? I know how to change
the entire background to 1 color, but need to be able to partition off
sections of the graph into different colors.