In Excel 365, as in prior versions, when changing chart design, if you go to templates, you can right click on a template and set it as default chart. This does not seem to work at all in Excel 365.
In Excel 365, as in prior versions, when changing chart design, if you go to templates, you can right click on a template and set it as default chart. This does not seem to work at all in Excel 365.
If you are using the home subscription you can get telephone support. If so, and you get an answer, please post it here.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
What do you mean by, "if you go to templates"? Can you give us a step-by-step?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
From Microsoft online:
Change the default chart type
Excel 2016 Excel 2013
If you click inside some data, and then press Alt+F1 on your desktop keyboard (or Alt+Fn+F1 on a laptop), Excel will provide a chart and use the default chart type. Usually this is a clustered column chart. But you can change the default if you want.
Select any chart.
On the Design tab, click Change Chart Type.
Select a chart type that you'd prefer being the default, but don't click OK just yet.
Look at the top of the All Charts tab, and find the chart icon that's highlighted in gray.
Right-click the chart icon that's highlighted in gray, and click Set as Default Chart.
Now when you press Alt+F1, that particular chart type will be used instead of the clustered column chart.
Tip: If Alt+F1 doesn't create a chart, your keyboard's F Lock button might be off. Turn it on, and then make sure to click inside some data before pressing Alt+F1.
That was they way it was done, back then, but in 365, it does not work. You cannot use a template as the default chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks