Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2019, 08:17 PM
Ashikido Ashikido is offline Graph in a cell of stock price between 52-week low-high. Windows 10 Graph in a cell of stock price between 52-week low-high. Office 2019
Novice
Graph in a cell of stock price between 52-week low-high.
 
Join Date: Dec 2019
Posts: 6
Ashikido is on a distinguished road
Default 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.
Attached Images
File Type: jpg SharedScreenshot.jpg (203.7 KB, 13 views)
Reply With Quote
  #2  
Old 12-24-2019, 10:40 AM
p45cal's Avatar
p45cal p45cal is offline Graph in a cell of stock price between 52-week low-high. Windows 10 Graph in a cell of stock price between 52-week low-high. Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

use sparklines; they're on the ribbon directly above Graph low-high:
Attached Images
File Type: jpg 2019-12-24_173532.jpg (8.5 KB, 13 views)
File Type: jpg 2019-12-24_174245.jpg (15.9 KB, 13 views)
Reply With Quote
  #3  
Old 12-24-2019, 05:03 PM
Ashikido Ashikido is offline Graph in a cell of stock price between 52-week low-high. Windows 10 Graph in a cell of stock price between 52-week low-high. Office 2019
Novice
Graph in a cell of stock price between 52-week low-high.
 
Join Date: Dec 2019
Posts: 6
Ashikido is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
use sparklines; they're on the ribbon directly above Graph low-high:
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".
Moreover, is there any way I can make it a straight line?
Thanks!
Reply With Quote
  #4  
Old 12-24-2019, 05:18 PM
p45cal's Avatar
p45cal p45cal is offline Graph in a cell of stock price between 52-week low-high. Windows 10 Graph in a cell of stock price between 52-week low-high. Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by Ashikido View Post
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 View Post
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.
Attached Images
File Type: jpg 2019-12-25_001109.jpg (61.0 KB, 11 views)
File Type: jpg 2019-12-25_002337.jpg (35.3 KB, 10 views)
Reply With Quote
Reply

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
Graph in a cell of stock price between 52-week low-high. 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
Graph in a cell of stock price between 52-week low-high. Week by week report thedeadzeds Excel 3 11-16-2013 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft