Chart Help-Add Horizontal Line

[Jym396]

I have a line chart with Dates on the X Axis (Jan 1-Dec 31)...and Hours on the Y Axis (0-12). I would just like to add a horizontal line (Series?) at 8 hours.

Thanks,
Jim

 

[Jym396]

I have a line chart with Dates on the X Axis (Jan 1-Dec 31)...and Hours on the Y Axis (0-12). I would just like to add a horizontal line (Series?) at 8 hours.

Thanks,
Jim

I forgot to say that there is a chart for every day of the week (Mon-Sun). So there are ~52 + min, max & avg...so 55 on the X Axis.
Jim

 

[Saba Sabaratnam]

Hi Jim,

You have already mentioned your solution.

Create another series for 8 hours for each day from Jan 1 to 31 Dec and plot it.

Kind regards

Saba

 

[Jym396]

I've tried but failed. Will try again! Thanks Saba