Line graph

[Stevetron]

Hello,

I am having a complete blank and need some help with a line graph. My original reason for posting was to find out if it is possible to have a line graph that recognises new data and auto updates.
However, I am having problems simply making the line graph. For some reason, after i set the vertical axis to a number, the plot lines have disappeared. Any help with this would be much appreciated.

I have added the sheet with the data via XL2BB, but cannot seem to add the graph, so i have copied and pasted below.

Thanks in advance.

NEW RESIN ratio record trial for graph.2.xlsx
	A	B	C	D	E
1
2	Date	Daily average		Upper limit	Lower limit
3	08-Jul	8.746		8.755	8.245
4	09-Jul	8.734		8.755	8.245
5	10-Jul	8.778		8.755	8.245
6	11-Jul	8.718		8.755	8.245
7	00-Jan	0.000		8.755	8.245
8	00-Jan	0.000		8.755	8.245
9	00-Jan	0.000		8.755	8.245
10	00-Jan	0.000		8.755	8.245
11	00-Jan	0.000		8.755	8.245
12	00-Jan	0.000		8.755	8.245
Sheet9 (2)

Cell Formulas
Range	Formula
A3:A12	A3	=OFFSET('July 2020'!$A$3,(ROW()-3)*5,0)
B3:B12	B3	=OFFSET('July 2020'!$N$3,(ROW()-3)*5,0)

 

[RoryA]

I doubt anyone can tell you why your chart isn't working without actually seeing it. Can you upload it to a site like OneDrive or Dropbox and then post a link here?

 

[Stevetron]

Apologies. Please see link

https://fraserantistatic-my.sharepo...dCo0Ao_BY8mOMBsTmi70g3nHfPdePMd21XxQ?e=LNvi8U

 

[RoryA]

That link doesn't appear to work externally (at least it doesn't for me).

 

[Stevetron]

https://fraserantistatic-my.sharepo...dCo0Ao_BY8mOMBsTmi70g3nHfPdePMd21XxQ?e=8DSqou

I have tried once more, if that doesnt work then may be work company has blocked sharing files online. Can i share it specifically with you?

 

[RoryA]

Didn't work, I'm afraid. Are you allowed to email files?

 

[Stevetron]

yes, i believe so

 

[RoryA]

I've just sent you my email address by private message. Once I have a chance to look at the workbook, I'll report my findings back here.

 

[RoryA]

You need to change the chart type to a normal line chart with markers, not a 100% stacked line chart.

 

[Stevetron]

Thank you Rory, worked a treat.

Now, is there a way for the chart to update automatically as data is input on the 'july2020' sheet? As you can see, the data the graph is formed from is grabbed from another sheet and updates daily. My objective is to have the run chart on display in our factory to show where the process is, but i want to make it as independent as possible. As in no user needs to update it.