How do I make a chart of surge pricing

Copper Contributor

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!

3 Replies

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??  

@Tobywon 

If you have data like this, select first clustered columns chart

image.png

Here click on second series and Change Chart Type

image.png

Select Line type for second series and apply it to secondary axis

image.png

The rest is cosmetic

@Tobywon 

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:

  1. Select Data
  2. Insert Tab >> Recommended Chart >> select the top option
  3. You then apply all kind of formatting you want.Combo 1.png

If you will be recreating similar charts later, then you can save time and effort by Saving your previously formatted chart as a Template:

  1. Right click on the Chart
  2. Select >> Save as Template
  3. Give a name to your TemplateCombo 2.png

Next time you want to recreate similar charts with same formatting:

  1. Select Data
  2. use the Shortcut ALT + F1
  3. Select "Change Chart Type from the Design Tab
  4. Click on Template Category
  5. Select Your Saved Template >>OKCombo 3.png

Combo 4.png

Hope that helps

Nabil Mourad