Help with Graph in excel 2000

wisconsinpat

New Member
Joined
Nov 19, 2017
Messages
1
Haven't used excel for years and forgot most everything
Here's what I'm trying to do

Produce line graph
Purchase for example an option ABBV ON 8/25/17 (Nov $15. call FOR 1.50) (THIS WOULD BE THE MEAN LINE ON LINE CHART)
ON THE CHART I WANT TO PLOT DAY BY DAY (5 days a week as market is open and not show closed days)
Then I want to show line daily above/below mean line as option value rises or falls showing $ amt. option price ended at around $13.00 within the next 30 days
this is basically what I want chart to show
If I could get step by step how to do this I's sure appreciate it. I did a 4 min youtube video to further explain below is the link https://youtu.be/xpBB4PSF4O8
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Here is one link to a tutorial on using the chart wizard to create charts.

https://www.thoughtco.com/bar-graph-column-chart-in-excel-3123560

I don't remember if xl2000 had the wizard, but I am pretty sure it did, because I was still working then and I made a lot of charts for metrics measurements for our department. The wizard makes it easy to build, modify and maintain a chart.
 
Upvote 0

Forum statistics

Threads
1,215,757
Messages
6,126,693
Members
449,331
Latest member
smckenzie2016

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top