# Line chart with multiple date-numbers traces

2»

• ✭✭✭✭✭✭

@Cory Bush Do you have a set start and end date for the chart or is it rolling dates, or...? I ask because we should be able to automate most of it if not all of it depending on your needs.

• The rolling dates are the last 92 days

• ✭✭✭✭✭✭

@Cory Bush Ok. That actually makes this process a little easier by having a set number of days to be displayed.

How do you determine which percentage to pull if there are multiple entries on the same date for the same operator?

• This is a new process for us, I believe we have some entry errors. I was trying to make it simple for the example. It is possible to have up to 3 shifts entering on the same date.

• ✭✭✭✭✭✭

3 shifts for the same CNC? If so, would you want the most recent one?

• I do believe the final draft will turn into 3 charts, one for each shift. Lets not worry about the different shifts.

What about making two lines from one column? V-CNC #1 and V-CNC #2

• ✭✭✭✭✭✭

If you are going to continue to have all 3 shifts entering their forms to the same sheet, we will still need to determine exactly which percentage to pull for each of the given dates. We can approach that later, but it can possibly affect the overall formula used to pull the percentages.

The basic idea is this...

Create another sheet with a single Date type column as well as two text/number type columns.

Based on your screenshots, it looks like you want the far left date to be today. In this case, you would simply enter

=TODAY()

in the first row of the date type column.

Then in row 2 you would enter

=[Date Column Name]1 - 1

Then dragfill this down until all 92 of your dates are in the sheet.

Then we would use formulas to pull the appropriate percentages based on the date and CNC# into each of the 2 text/number columns. This particular formula will depend on your exact setup and details though.

• Paul, Have a question in regards to a line chart I'm having issues with. Comparing project budget hours to actuals. Can you help?

I need to create a line graph with two lines showing budget vs actuals for each project on the first column.