Line graph

Stevetron

New Member
Joined
Jul 9, 2020
Messages
28
Office Version
  1. 365
Platform
  1. Windows
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.
1594622774064.png


NEW RESIN ratio record trial for graph.2.xlsx
ABCDE
1
2DateDaily averageUpper limitLower limit
308-Jul8.7468.7558.245
409-Jul8.7348.7558.245
510-Jul8.7788.7558.245
611-Jul8.7188.7558.245
700-Jan0.0008.7558.245
800-Jan0.0008.7558.245
900-Jan0.0008.7558.245
1000-Jan0.0008.7558.245
1100-Jan0.0008.7558.245
1200-Jan0.0008.7558.245
Sheet9 (2)
Cell Formulas
RangeFormula
A3:A12A3=OFFSET('July 2020'!$A$3,(ROW()-3)*5,0)
B3:B12B3=OFFSET('July 2020'!$N$3,(ROW()-3)*5,0)


1594622774064.png
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
That link doesn't appear to work externally (at least it doesn't for me).
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Didn't work, I'm afraid. Are you allowed to email files?
 

Stevetron

New Member
Joined
Jul 9, 2020
Messages
28
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

yes, i believe so
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You need to change the chart type to a normal line chart with markers, not a 100% stacked line chart. :)
 

Stevetron

New Member
Joined
Jul 9, 2020
Messages
28
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,349
Messages
5,635,768
Members
416,879
Latest member
Excel_Newbie4980

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
Top