We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
excel - plotting a graph from figures
longwalks1
Posts: 3,834 Forumite
in Techie Stuff
I've started a very simple spreadsheet with 3 columns (I'm following a share price). The 3 columns are:
Day low
Day high
Day finish price
How hard will it be to plot a basic 'left to right' graph with 3 lines, with the area between 'day low' and 'day high' shaded in?
Hope that makes sense
Thanks in advance
Day low
Day high
Day finish price
How hard will it be to plot a basic 'left to right' graph with 3 lines, with the area between 'day low' and 'day high' shaded in?
Hope that makes sense
Thanks in advance
0
Comments
-
Have a look here:
http://peltiertech.com/WordPress/fill-under-between-series-in-excel-chart/
Caveat: I've not tried it myself, it's in my clipbook of stuff I've been meaning to get round to trying out
0 -
You need a row... Day. After that, the graph is simple. The. You can either do a hi/lo graph or a shaded normal graph. (I'm assuming you're running excel 2007 or later)1. Have you tried to Google the answer?
2. If you were in the other person's shoes, how would you react?
3. Do you want a quick answer or better understanding?0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.4K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.4K Spending & Discounts
- 245.5K Work, Benefits & Business
- 601.3K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.3K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards