Home

Trying to make a chart template be the default chart

%3CLINGO-SUB%20id%3D%22lingo-sub-11587%22%20slang%3D%22en-US%22%3ETrying%20to%20make%20a%20chart%20template%20be%20the%20default%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-11587%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20favorite%20way%20to%20create%20perfect%20charts%20in%20one%20keystroke%3A%3C%2FP%3E%3CP%3E1.%20Create%20a%20chart%20with%20Alt%2BF1%20and%20you%20get%20a%20clustered%20column%20chart.%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Customize%20that%20chart%20to%20match%20your%20preferred%20chart%20style.%3C%2FP%3E%3CP%3E3.%20Right-click%20the%20chart%20and%20Save%20as%20Template.%20Give%20the%20template%20a%20name%20and%20save.%3C%2FP%3E%3CP%3E4.%20With%20the%20chart%20selected%2C%20choose%20Change%20Chart%20Type.%20Navigate%20to%20the%20Templates%20folder.%20Right-click%20your%20template%20and%20choose%20Set%20as%20Default%20Chart.%3C%2FP%3E%3CP%3E5.%20Click%20OK%20to%20close%20the%20dialog.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20future%2C%20you%20can%20select%20your%20data%2C%20press%20Alt%2BF1%2C%20and%20all%20of%20the%20settings%20from%20step%202%20will%20be%20applied.%20It%20is%20a%20big%20time%20saver.%20I've%20featured%20this%20trick%20on%20my%20YouTube%20channel%20several%20times%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dc8uokJztHTY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dc8uokJztHTY%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcept%3A%20it%20was%20recently%20broken%20in%20Office%20365%20First%20Release%20channel.%20It%20still%20works%20in%20Excel%202013%20and%20all%20past%20versions.%20Is%20this%20functionality%20being%20depracated%20on%20purpose%3F%20I%20understand%20you%20are%20moving%20to%20a%20new%20Ivy%20charting%20engine%2C%20but%20it%20is%20a%20great%20time-saver%20for%20people%20who%20routinely%20have%20to%20create%20the%20same%20type%20of%20charts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-11587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20and%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
MVP

My favorite way to create perfect charts in one keystroke:

1. Create a chart with Alt+F1 and you get a clustered column chart. 

2. Customize that chart to match your preferred chart style.

3. Right-click the chart and Save as Template. Give the template a name and save.

4. With the chart selected, choose Change Chart Type. Navigate to the Templates folder. Right-click your template and choose Set as Default Chart.

5. Click OK to close the dialog.

 

In the future, you can select your data, press Alt+F1, and all of the settings from step 2 will be applied. It is a big time saver. I've featured this trick on my YouTube channel several times: https://www.youtube.com/watch?v=c8uokJztHTY

 

Except: it was recently broken in Office 365 First Release channel. It still works in Excel 2013 and all past versions. Is this functionality being depracated on purpose? I understand you are moving to a new Ivy charting engine, but it is a great time-saver for people who routinely have to create the same type of charts.

 

Thanks

Alt+F1 creates a clustered column chart. But you can customize Alt+F1 to create the perfect chart for your job. Recap: F11 was the old shortcut key to create...
Related Conversations