Jun 28 2019 04:15 PM
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 line graph above it. The takeaway needs to be when a venue gets crowded, the price goes up driving down demand...like Uber surge pricing! Thanks for your help!
Jun 28 2019 04:22 PM
After thinking about it ,a common chart is for stocks; where the volume is in bars at the bottom of the chart and the price is on a line above. This would work perfectly!! How to do??
Jun 29 2019 03:12 AM
If you have data like this, select first clustered columns chart
Here click on second series and Change Chart Type
Select Line type for second series and apply it to secondary axis
The rest is cosmetic
Jun 29 2019 11:03 AM
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:
If you will be recreating similar charts later, then you can save time and effort by Saving your previously formatted chart as a Template:
Next time you want to recreate similar charts with same formatting:
Hope that helps
Nabil Mourad