Graph in a cell of stock price between 52-week low-high.

p45cal · #1 12-24-2019, 05:18 PM

Quote:

Originally Posted by Ashikido

Hi, thanks for replying.
The problem is that they are not proportionate.
The point in the middle (current price) should be closer to the "low".

Play with (the graphics below).

Quote:

Originally Posted by Ashikido

Moreover, is there any way I can make it a straight line?

Thanks!

What?! How can you ask this? How can the middle point be proportional as you ask AND have them in a straight line?! The only way is if the three points happen to fall in a straight line.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating 2 percentage fields to show the progress from week to week	Loay harhash	Project	0	04-03-2018 03:26 AM
Smart Tag - Insert Refreshable Stock Price	paschalleddie1	Excel	0	10-23-2017 04:12 PM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)	lily	Excel	9	10-23-2014 06:21 AM
Priority of line graph vs bar graph in terms of front to back positioning on a chart	DavePPointuser	PowerPoint	1	04-30-2014 10:57 AM
Week by week report	thedeadzeds	Excel	3	11-16-2013 02:06 AM