Staright Line Chart

[excelsishya]

Hi all,

I am looking For Straight Line (Horizontal) to be used in P/E Trading COMPS.

Please see link below to get the sample sheet where i drawn it using drawing tools i am hoping to get it in excel chart.

http://www.4shared.com/file/UF_lowRA/Sample_book.html

it has straight line (horizontal) with min and max P/E multiple as end Points(5,50)

between the line there will be individual company P/E (say 15X) represented by marker(triangle) and next to it 25x industry P/E marker(rectangle).

Data set will be same 4 data points.

Apologies if it is not clear i am not sure know to put drawings questions to post using Jeanie.


Thanks

 

[excelsishya]

Steve ,Thanks for video tutorial.

I was able to create chart after watching video.some of tricks you showed i can also apply in other chart creation.

When i 1st posted question couple of days i had no answer. i though it was not possible in excel.Your charting skills are Top notch.

Thanks again.

 

[Steve=True]

Hi, thanks for the kind words.

Glad the tutorial helped.

I would like to help build the enhancements you would like as well.

I sent you a private message with my email for you to send data/explainations,

Hope to hear from you about building bigger and better charts.

Thanks

Steve=True
www.exceldashboardtemplates.com