Introducing The Add-in That Will FOREVER Change The Way You Work With Charts

Creating charts in Excel is a great way to bring visualization to your data. It is often the best way to quickly draw conclusions about trends and points of interest. For that very reason, it is vital that analysts have the ability to develop and manipulate charts to tell a story.

I’m sure you’ve been in situations before where much is wanted and time is short. Have you ever faced similar scenarios?

• You need to create charts for all 50 of your Store’s sales for the past three months for a meeting in 30 minutes.

• Someone from another department sends you charts to add to your presentation but the colors they used don’t match the rest of the charts you’ve already created

• Your boss wants the Y-axis removed and a legend inserted for all your charts analyzing client trends

• It’s budget time and you need to add next year’s data to all your charts, effectively extending each of the chart series 12 more months

While Excel makes it super easy to create and edit a single chart, it can be quite cumbersome to manipulate a whole bunch of charts, especially if time is of the essence! Luckily, with the AutoChart Excel add-in, you can accomplish all those scenarios above and more within minutes not hours!

Let’s take a look at what AutoChart can do for you!

Creating the same chart over and over again can be a real pain and waste a TON of time! With the Replicate Charts button, you can create 100 different charts in mere seconds!

Take this example. You need to create a chart for each of your company’s stores….and your company owns a lot of stores! With the AutoChart add-in you can simply create your first chart and format it just the way your want it and then use the Replicate button to create the rest of the charts. No need to re-link the chart series or chart title. The add-in does all the work for you!

How It Works

The trick to quickly replicating your charts lies in the structure of your source data. The Replicate Charts button relies on the chart data being spaced predictably row-by-row (or column-by-column). By creating the first chart at the beginning of your data set, AutoChart can then continue down the rows of data creating however many charts you wish.

To get the replicated charts created exactly how you want them, a dialog box will appear asking how exactly you want your charts adjusted and spread out across the spreadsheet. The Replicate functionality will even adjust the formulas in your Series Names and Chart Title if you want it to!

The Extend Chart(s) button allows you to expand or compress all of the chart series ranges within your selection by a given number. This functionality is extremely useful when you need to add another year’s worth of data to your chart or quickly create different chart views on the fly.

All you need to do is

1. Select your target chart(s)

2. Click the Extend Chart(s) button

3. Input how many cells you want to increase/decrease the series range

You can perform this function with a single chart or multiple selected charts at once! Essentially allowing you to perform your series range adjustments within a few seconds.

Do you find yourself always removing or adding certain elements to your charts every time you create one? Chances are you don’t like Excel’s default chart format or presets. With AutoChart, you can use the built-in Simple Clean button to tidy up your charts or create up to 10 custom presets.

Quickly Clean Up Your Charts

The built-in Simple Clean preset allows you to modify the following chart features with the click of a button:

• Title Position (or choose to remove it)

• Legend Position (or choose to remove it)

• Remove Gridlines

• Remove Chart Border

• Add A Transparent Fill

• Remove Line Markers

Simple Clean In Action!

Below on the left is an example of a default Excel chart format upon creation. By selecting the new chart and clicking the Clean Chart option within AutoChart, you can quickly modify a few of the chart elements to get them the way you like.

Create Your Own Presets!

If the Simple Clean preset does not fulfill your formatting needs, you can easily create your own chart preset (up to 10)!

1. Create a chart that is formatted just the way you want it

2. Click the Clean Chart Create/Edit button

3. Give your preset a name

4. Click the Save Preset button

After you save a preset, a new button will appear in your Clean Chart drop-down menu. And of course, if you have a favorite preset you can make it your default preset so you don’t have to select it from the drop-down menu each time.

A Custom Clean Preset In Action!

Let’s take that same Excel chart we started with before and apply a custom preset that we made to get the graph formatted specifically the way we want it. Again, with the click of a button, you can transform the default Excel format into your preferred format. This can literally shave off 10 minutes of formatting time per every single chart you need to format!

The AutoChart Excel Add-in allows you to store up to 12 separate RGB color codes to create your own branding preset. Simply add the RGB color codes to the Settings Userform and you are ready to go apply branding to all those charts your co-workers don’t take time to format properly.

You can even brand all your charts at once! Just select the ones you want to brand and click the Brand Series button. Magically, all your selected chart series share the exact colors you want them to… no matter what chart type they are

A Free 14-Day Trial Just For You

I personally couldn’t live without this add-in but I can understand if you think you may not use it. That is why I am willing to provide you with a trial version of this add-in so you can try it completely free for 2 weeks. I don’t lock down any of the features, so you have complete access to every functionality!