Custom Charts in Excel :: How to Reuse Without Recreating it Time and Again

Posted: May 4, 2013 by MaxFraudy in Excel, General Tips
Tags: , ,

Re-creating Custom Charts

Re-creating Custom Charts Can be Frustrating

Excel provides us with many chart types and those of us who work with data representation or create dashboards know that they are not enough. We do need to create custom chart types every now and then to satisfy specific needs. At the same time, some of these custom charts are so frequently used that it becomes frustrating to re-create them each and every time. But don’t worry, Microsoft is considerate enough to provide a solution to this.

Excel has a feature known as templates. It is widely used for workbooks but it applies to charts as well. If there are certain charts that you use on a regular basis then you can save them as a chart template (.crtx) in the template folder. When you need to use it again, all that you need to do is create a chart using your data. Change it’s chart type. In the dialog box that appears, go to ‘Templates‘ and select your template.

Easy peasy 🙂

I have not give out detailed instructions since Microsoft has already done a great job of it at their website.

Amazing how we miss out certain things that are always in front of us. This option is there, but not many people use it. I think we should.

 

More in Custom Charts:

Custom Charts in Excel :: Thermometer Chart

Custom Charts in Excel :: Heatmap Inspiration

 

 

Advertisements

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s