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.

Excel Auto formatting graphs

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.

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]