Home

How do I make a chart of surge pricing

%3CLINGO-SUB%20id%3D%22lingo-sub-729322%22%20slang%3D%22en-US%22%3EHow%20do%20I%20make%20a%20chart%20of%20surge%20pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI'm%20new%20at%20making%20charts%20and%20I%20need%20a%20chart%20(bar%20possibly)%20where%20the%20number%20of%20people%20is%20represented%20by%20a%20bar%2C%20then%20a%20price%20is%20reflected%2C%20possibly%20on%20the%20same%20bar%20with%20split%20values%2C%20or%20with%20a%20line%20graph%20above%20it.%20The%20takeaway%20needs%20to%20be%20when%20a%20venue%20gets%20crowded%2C%20the%20price%20goes%20up%20driving%20down%20demand...like%20Uber%20surge%20pricing!%20Thanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729322%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729329%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20chart%20of%20surge%20pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729329%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20thinking%20about%20it%20%2Ca%20common%20chart%20is%20for%20stocks%3B%20where%20the%20volume%20is%20in%20bars%20at%20the%20bottom%20of%20the%20chart%20and%20the%20price%20is%20on%20a%20line%20above.%20This%20would%20work%20perfectly!!%20How%20to%20do%3F%3F%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729516%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20chart%20of%20surge%20pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368559%22%20target%3D%22_blank%22%3E%40Tobywon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20data%20like%20this%2C%20select%20first%20clustered%20columns%20chart%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20314px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121654i24BA54DA5986DDE6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%20click%20on%20second%20series%20and%20Change%20Chart%20Type%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20308px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121655iB222693157B6CFBE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESelect%20Line%20type%20for%20second%20series%20and%20apply%20it%20to%20secondary%20axis%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20463px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121656iE29C824872B6F206%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20rest%20is%20cosmetic%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729730%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20chart%20of%20surge%20pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368559%22%20target%3D%22_blank%22%3E%40Tobywon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWhen%20you%20have%202%20data%20series%20where%20one%20shows%20large%20numbers%20and%20the%20second%20shows%20small%20numbers%20(see%20attached%20file)%20then%20a%20Combo%20chart%20is%20the%20best%20choice.%3C%2FP%3E%3CP%3EAn%20easy%20way%20to%20create%20it%20is%3A%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20Data%3C%2FLI%3E%3CLI%3EInsert%20Tab%20%26gt%3B%26gt%3B%20%3CSTRONG%3ERecommended%20Chart%3C%2FSTRONG%3E%20%26gt%3B%26gt%3B%20select%20the%20top%20option%3C%2FLI%3E%3CLI%3EYou%20then%20apply%20all%20kind%20of%20formatting%20you%20want.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121675iB0001664F7D7C4A8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%201.png%22%20title%3D%22Combo%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIf%20you%20will%20be%20%3CSTRONG%3Erecreating%20similar%20charts%20later%3C%2FSTRONG%3E%2C%20then%20you%20can%20save%20time%20and%20effort%20by%20Saving%20your%20previously%20formatted%20chart%20as%20a%20Template%3A%3C%2FP%3E%3COL%3E%3CLI%3ERight%20click%20on%20the%20Chart%3C%2FLI%3E%3CLI%3ESelect%20%26gt%3B%26gt%3B%20%3CSTRONG%3ESave%20as%20Template%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EGive%20a%20name%20to%20your%20Template%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121676i2C23D701D9609742%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%202.png%22%20title%3D%22Combo%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3ENext%20time%20you%20want%20to%20%3CSTRONG%3Erecreate%20similar%20charts%20with%20same%20formatting%3C%2FSTRONG%3E%3A%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20Data%3C%2FLI%3E%3CLI%3Euse%20the%20Shortcut%20ALT%20%2B%20F1%3C%2FLI%3E%3CLI%3ESelect%20%22Change%20Chart%20Type%20from%20the%20Design%20Tab%3C%2FLI%3E%3CLI%3EClick%20on%20Template%20Category%3C%2FLI%3E%3CLI%3ESelect%20Your%20Saved%20Template%20%26gt%3B%26gt%3BOK%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20860px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121677i739237A5651AD272%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%203.png%22%20title%3D%22Combo%203.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121678iDB959578AFA534FE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%204.png%22%20title%3D%22Combo%204.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729731%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20chart%20of%20surge%20pricing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729731%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368559%22%20target%3D%22_blank%22%3E%40Tobywon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWhen%20you%20have%202%20data%20series%20where%20one%20shows%20large%20numbers%20and%20the%20second%20shows%20small%20numbers%20(see%20attached%20file)%20then%20a%20Combo%20chart%20is%20the%20best%20choice.%3C%2FP%3E%3CP%3EAn%20easy%20way%20to%20create%20it%20is%3A%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20Data%3C%2FLI%3E%3CLI%3EInsert%20Tab%20%26gt%3B%26gt%3B%20%3CSTRONG%3ERecommended%20Chart%3C%2FSTRONG%3E%20%26gt%3B%26gt%3B%20select%20the%20top%20option%3C%2FLI%3E%3CLI%3EYou%20then%20apply%20all%20kind%20of%20formatting%20you%20want.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121675iB0001664F7D7C4A8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%201.png%22%20title%3D%22Combo%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EIf%20you%20will%20be%20%3CSTRONG%3Erecreating%20similar%20charts%20later%3C%2FSTRONG%3E%2C%20then%20you%20can%20save%20time%20and%20effort%20by%20Saving%20your%20previously%20formatted%20chart%20as%20a%20Template%3A%3C%2FP%3E%3COL%3E%3CLI%3ERight%20click%20on%20the%20Chart%3C%2FLI%3E%3CLI%3ESelect%20%26gt%3B%26gt%3B%20%3CSTRONG%3ESave%20as%20Template%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EGive%20a%20name%20to%20your%20Template%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121676i2C23D701D9609742%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%202.png%22%20title%3D%22Combo%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3ENext%20time%20you%20want%20to%20%3CSTRONG%3Erecreate%20similar%20charts%20with%20same%20formatting%3C%2FSTRONG%3E%3A%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20Data%3C%2FLI%3E%3CLI%3Euse%20the%20Shortcut%20ALT%20%2B%20F1%3C%2FLI%3E%3CLI%3ESelect%20%22Change%20Chart%20Type%20from%20the%20Design%20Tab%3C%2FLI%3E%3CLI%3EClick%20on%20Template%20Category%3C%2FLI%3E%3CLI%3ESelect%20Your%20Saved%20Template%20%26gt%3B%26gt%3BOK%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20860px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121677i739237A5651AD272%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%203.png%22%20title%3D%22Combo%203.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121678iDB959578AFA534FE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Combo%204.png%22%20title%3D%22Combo%204.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Tobywon
New 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
Highlighted

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

Highlighted

@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

Related Conversations
Figuring Out Our Teams Needs
olichance in Microsoft Teams on
12 Replies
my chart can not smooth the points
inadotb in Excel on
2 Replies
Pricing for Security Events Ingestion
anthony_wagov in Azure Sentinel on
1 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies