#1
|
|||
|
|||
Graph in a cell of stock price between 52-week low-high.
Hi!
Please see attached screenshot. I am running Excel 365. I would like to embed a graph into the empty cell "Graph low-high". For this graph, I would like to visualize 3 points: 52-w low price, current price, and 52w high. The way I see it, it should be a line with three dots. Does anyone know how to make that happen? Thanks and happy holidays. |
#2
|
||||
|
||||
use sparklines; they're on the ribbon directly above Graph low-high:
|
#3
|
|||
|
|||
Quote:
The problem is that they are not proportionate. The point in the middle (current price) should be closer to the "low". Moreover, is there any way I can make it a straight line? Thanks! |
#4
|
||||
|
||||
Quote:
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. |
Tags |
excel 2019., graph, stocks |
Thread Tools | |
Display Modes | |
|
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 |