Forum Discussion
Tobywon
Jun 28, 2019Copper Contributor
How do I make a chart of surge pricing
Hi I'm new at making charts and I need a chart (bar possibly) where the number of people is represented by a bar, then a price is reflected, possibly on the same bar with split values, or with a lin...
nabilmourad
Jun 29, 2019MVP
Hi
When you have 2 data series where one shows large numbers and the second shows small numbers (see attached file) then a Combo chart is the best choice.
An easy way to create it is:
- Select Data
- Insert Tab >> Recommended Chart >> select the top option
- You then apply all kind of formatting you want.
If you will be recreating similar charts later, then you can save time and effort by Saving your previously formatted chart as a Template:
- Right click on the Chart
- Select >> Save as Template
- Give a name to your Template
Next time you want to recreate similar charts with same formatting:
- Select Data
- use the Shortcut ALT + F1
- Select "Change Chart Type from the Design Tab
- Click on Template Category
- Select Your Saved Template >>OK
Hope that helps
Nabil Mourad