• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I have problem creating a price volume chart. Please Help

B

Baama2

New Member
My Dear Mr. Excel,


I am baffled by how a chart was created. I went to a job interview and I was asked to create a chart in Excel. I tried everything I know but I could not create the chart. This is not the first time I have tried this chart. Please see attached.

I have another interview next week, and I am afraid this chart will be waiting for me. It would very much appreciated if you could help.


Please see attached.



Thanks you in advance
 

Attachments

  • Price Volume chart.xlsx
    29.6 KB · Views: 7
Hi Baama,

I am little confused What and why you want to do this.

As far I understand, In excel you can not add multiple "Horizontal axis" range. so logically you can not do this but if you really want to achieve this, you can make 2charts "One over the other".

Below, I have changed the "Horizontal axis" to dates.

upload_2016-8-17_11-5-34.png
Baama2 said:
My Dear Mr. Excel,


I am baffled by how a chart was created. I went to a job interview and I was asked to create a chart in Excel. I tried everything I know but I could not create the chart. This is not the first time I have tried this chart. Please see attached.

I have another interview next week, and I am afraid this chart will be waiting for me. It would very much appreciated if you could help.


Please see attached.



Thanks you in advance
Click to expand...
 
Thank you but this is not what I am looking for. Unfortunately I did not take a screen shot. I believe there is a trick to solving this puzzle
 
The copy I downloaded (above) seemed to indicate you needed help with the CLOSE chart - specifically getting the dates to fill across the horizontal/bottom axis. I went to SELECT DATA to see what range you had selected and it was blank. I added the range of A2:B243 and the dates filled across nicely.

Was there a different issue for you?
 
Thanks. Please look how the chart has line has change drastically. the wavy form has gone. It did not work. Unfortunately I did not take screen shot of the final
 
Hey candybg,

It would be great if you can upload solved sheet. :)
[
quote="candybg, post: 183652, member: 26146"]The copy I downloaded (above) seemed to indicate you needed help with the CLOSE chart - specifically getting the dates to fill across the horizontal/bottom axis. I went to SELECT DATA to see what range you had selected and it was blank. I added the range of A2:B243 and the dates filled across nicely.

Was there a different issue for you?[/quote]
 
I took this test at citigroup location here in NY but I did not take a screenshot they only had the solved in a print out. I should have taken a picture of it but there was a supervisor. They had lot o candidates coming in to try out.
 
Here is your spreadsheet, with the DATA RANGE changed for the CLOSE chart.

Was this what you expected or did you want something different?
 

Attachments

  • Price Volume chart-V2xlsx.xlsx
    30.6 KB · Views: 5
Thanks for you effort but it was a combined a chart. the close as a line chart and volume as a bar chart but chart is using the dates of the volume as the horizontal axis
 
I'm so sorry I don't understand your request. I can make several more guesses, but don't know exactly waht you want. Can you try to draw me a mental picture of what you want as your final outcome?
 
Please see attached sample picture on the bottom of the page. Thanks for your efforts. You may also refer me to some one who might solve the problem. They have this at citigroup location as a test for candidates applying for a job.
 

Attachments

  • Price Volume chart.xlsx
    58.4 KB · Views: 6
Hi Baama2,

Is this the solution what you want? if not and you remember the image (chart) just draw and share with us.

will try to resolve this. :)

Baama2 said:
Please see attached sample picture on the bottom of the page. Thanks for your efforts. You may also refer me to some one who might solve the problem. They have this at citigroup location as a test for candidates applying for a job.
Click to expand...
 
You must log in or register to reply here.
Back
Top