Graphs in Excel

[Taryn Lynn]

I am having trouble updating some production graphs I have in Excel. I formatted this spreadsheet over a year ago and I now need to add additional dates to the major axis. When I add the dates parts of the existing graph lines disappear. Capture.JPG


I attempted to attach a picture. Please let me know if there is anything I can do to fix this. Thank you.


Taryn Lynn

[Andy Pope]

you need to attach example file.

a picture does not help, especially if the thing you are trying to show has disappeared!

[Taryn Lynn]

Production (TRUSS) 425310.xlsx ...The file has 4 tabs. The first two pull to the 4th and the 3rd (which has the graphs) putt information from the 4th tab. I know it's probably not set up the best way but it was working and giving me the information I needed. All I want to do is add dates so I can track the production longer.

[Andy Pope]

Series 1 has this formula =SERIES("Budgeted Production",Sheet2!$E$7:$E$38,Sheet2!$C$7:$C$69,1)

Series 2 has this formula =SERIES("Weekly Production",Sheet2!$E$7:$E$69,Sheet2!$F$7:$F$27,2)

Ideally the start and finish rows for both data and categories should be the same.
Use the select data dialog to adjust each series Values and Category references to the correct ranges.

[Taryn Lynn]

The reason why those series do not match up is because I track the production on a weekly basis. The budgeted production should have nothing to do with the weekly production. If you look at the graphs below the first one you will see that those work out just fine. It's not until I add additional dated to the major axis that everything starts to get a little funny. I just don't understand how adding dates could change the information that already exists on the graph.

[Andy Pope]

I've moved the top chart to sheet2 so you can see the data used by the series and how that is displayed.

Let us know what you was expecting in the chart in terms of content.

[Taryn Lynn]

What I need this chart to do is show the trend, over time, of how these repairs are performing. Series 1 is a constant and will never change which is the reason I have it carried out until the last date on the major axis. Series 2 and Series 3 are added each week based on quantities and hours which are input into the first 2 tabs in the workbook. The goal is to show how the "Weekly" and "To Date" data plots against the "Budgeted". Before I added the additional dates to this top graph everything plotted just fine and I didn't have any holes in my series lines. If you are to reset the dates back to 10/25/14 on the first graph everything goes back to normal.

[Andy Pope]

Check you dates, specifically those in row 48.

[newdoverman]

One way is to have the source data in a table. I have created a table and a new chart but had to enter a value to satisfy an error caused by missing data. The cells in question are formatted with a red background.

[Taryn Lynn]

Not every week is listed in the graph because some weeks we did not do these specific repairs. Instead of letting the value drop off to "0" due to no activity that week I simply deleted that date. The reason why these is data missing is because during that week we coded time to something we had no quantity for. This happens but not that often so when I deal with that I have to let the graph fall off to "0" to show we made a mistake that week.

[Andy Pope]

if you check row 48 you will see the data is a year out of sequence. This is causing the gap in your green line.

[Taryn Lynn]

I corrected it and it work. I can't believe I input that date wrong. Thank you so much for all your help. I hope you both have a great day.

[newdoverman]

Thanks for the feedback.

Good luck.