Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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,850
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
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards