Often we come across workbooks that have similar formatting needs for multiple worksheets. For eg. you may have sales records spanning across 12 worksheets, one for each month. Now as a loyal reader of chandoo.org, you want to keep the formatting of all these worksheets consistent. So here is a quick tip to begin your work week.
- Just select all the different sheets (select one, then hold CTRL key and click on other sheet names).
- Now format any sheet and similar formatting will be applied to all selected sheets
- See this demo to understand:
The group & format technique is particularly useful when you,
- Want to apply same header / footer / print settings to multiple worksheets
- Want to write similar formulas in multiple worksheets (for eg. totals)
Do you use group sheets option?
I like to have consistent look & feel for all my worksheets. Especially if I am doing it for a client or for a product. So I find group sheets option pretty attractive and productive.
What about you? Do you use it? Share your tips & ideas with us.
More Quick Tips:
We have more than 60 quick excel tips that boost your productivity or introduce a new feature to simplify your work. Each of them is bite sized so you can learn quickly. Go on and consume a quick tip.
8 Responses to “Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]”
[...] Select the “daily completed” column and add it to the burn down chart. Once added, change the chart type for this series to bar chart (read how you can combine 2 different chart types in one) [...]
[...] set the height series to be plotted on secondary axis. Learn more about combining 2 chart types and adding secondary axis in [...]
[...] Excel Combination Charts – What are they? [...]
[...] To show the years, I have used another dummy series and plotted it on secondary axis (related: how to add secondary axis?) [...]
Thanks for this one!
[...] Choisissez la colonne « Daily Completed » et ajoutez-la au graphique. Une fois ajoutée, changez le type de graphique pour cette série à histogramme (lisez comment combiner 2 types de graphiques en un : combine 2 different chart types in one) [...]
How do i create a chart that has negative numbers on axis x and y and plot them correctly? I cannot seem to understand how to do this, please help.
Thanks.
Nat
You can also plot 2 or more Y axes in Excel using EZplot or Multy_Y from Office Expander.com
There is a demo version to try.
Cheers.