Hi
i have a job to do which involves creating a large number of charts from a series of Excel 2016 data sheets and pivot tables built on this data. The process requires judgement on what to chart and so i don’t really want to get into writing macros I don’t think.
I have set set up a series of 12 chart templates in the house style and these work great. The workflow is:
I have done hundreds of these this weekend and have many more hundreds to do so any time savings I can make will really help.
the slow bit for me is making the chart. I have an insert chart quick access button but I have to click through recommended charts to templates before I can chose which one I want. Is there a keyboard shortcut or some way of bringing up my templates in one click or press?
thanks for any tips.
Phil
i have a job to do which involves creating a large number of charts from a series of Excel 2016 data sheets and pivot tables built on this data. The process requires judgement on what to chart and so i don’t really want to get into writing macros I don’t think.
I have set set up a series of 12 chart templates in the house style and these work great. The workflow is:
- Pivot table to get required view
- copy and paste to a new tab
- create the required chart
- move the chart to its own tab
- when set completed I have an xlsx containing all the charts and data for future tweaks
I have done hundreds of these this weekend and have many more hundreds to do so any time savings I can make will really help.
the slow bit for me is making the chart. I have an insert chart quick access button but I have to click through recommended charts to templates before I can chose which one I want. Is there a keyboard shortcut or some way of bringing up my templates in one click or press?
thanks for any tips.
Phil