Chart Line

DDH

Well-known Member
Joined
Sep 25, 2003
Messages
513
I made a chart with several different months on it and
I had a red vertical line come up showing where the
month changed.
That was very cool, but some how I lost it and I
can not figure out how I done it or what I done to lose it.
I have been through everything on the chart menus.
Thank you for your help.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
It was probably an additional series that was deleted or is now out of your axis range or the line was changed to no color.

Have you looked to see if all your series are being displayed?

if not, you can correct that.

If they are all displayed, then you will have to most likely add a new series for this.

What type of chart is it? Column, bar, xy, area?

What version of Excel?

There is a demonstrationon adding a horiztonal and vertical intersecing lines at:

www.exceldashboardtemplates.com

Steve=True
 
Upvote 0
Steve=True - Thank you for your help.
1. All of my series are being displayed.
2. It is a line chart.
3. Microsoft Office Excel 2007

I had never seen a vertical line running from top to bottom
when the data changed months.
I have been through every option I could touch and
I can not get it to come back.
The data the chart is drawing on is daily.
Thank you for your help.
 
Upvote 0
I sent you a private message with my so i can help you fix your issue.

Send me your file if you can and i will see if i can fix the problem
 
Upvote 0
Steve=True - I sent the file.
The line was going vertical between 7-31 and 9-1 on the chart.

Thank you for the help
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,283
Members
452,902
Latest member
Knuddeluff

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
Back
Top