We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 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
Options
longwalks1
Posts: 3,824 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
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.2K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards