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.
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) |