Auto format on an excel chart? What?
Yes. It is too good to be true.
In fact it is not true in the strict sense.
I have crated a chart for you that is automatically color itself based on the data.
For convenience I uploaded it into a video for you, but let’s talk about it for a second.
The chart itself can’t be formatted with conditional formatting as such.
So I created two helper column that I use in the chart and display them as if they are one.
We can use these column chart as this is the best chart type for this. For example a pie chart would not make much sense in our case. But there are many chart in excel, maybe one of you will figure out how to create a chart with the same auto formatting. If that’s the case give us a shout.
But enough of talking let’s have the video.
Sorry that this post was rather short, but I have to dash to work.
If you want take a look around at our Other Categories too, or check us out on Facebook, and drop us a like if you think this post helps the community.