Multi page chart

**matthew1968** · 08-22-2018, 02:56 PM

Hi
I do not seem to be having much luck with what you guys would probably class as a simple task, i want 3 page of data with a chart for each then a final page with a chart made up from the first 3 pages. They seem to be adding together rather than joining on last page individual. I have attached what i have so far

**protonLeah** · 08-22-2018, 03:13 PM

Just change the type to "column" not "line". The counts are not functions of (dependent on ) the dates.

**matthew1968** · 08-22-2018, 03:21 PM

sorry my fault i want a line graph but sheet one seems to add to sheet two. For example i have no data in december for headlamp LH yet my graph shows i have data on around the 17th december. I do not know where it gets that data

**MrShorty** · 08-22-2018, 03:25 PM

sheet one seems to add to sheet two.

This is standard behavior for a stacked line chart. If you don't want the series to stack (add) on top of each other, then change chart type to a regular line chart.