Bar Char + XY Chart Need Help With Inserting Dummy Line

**John Vieren** · 10-09-2009, 04:21 AM

Dear All,

Thank you for reading my posting.

Attached please find my chart (which is rather complex)

The problem I am having is to make an xy line which covers all my data.

Please see attached in 2019 the line does not appear.

I have 2 question, does any have an add in to insert lines anywhere and how to solve this particular problem?

Thank you and kindest regards JV

**Andy Pope** · 10-09-2009, 06:58 AM

Try setting the last dummy xy-series to having 2 values.
And fix the secondary x axis to a maximum of 1.

Not sure there is an addin. But all you need to do is enable the secondary x axis.
Right click chart > Chart Options > Axes.

**John Vieren** · 10-10-2009, 04:24 AM

Thank you very much

Bar Char + XY Chart Need Help With Inserting Dummy Line

LinkBack

Thread Tools

Rate This Thread

Display

Bar Char + XY Chart Need Help With Inserting Dummy Line

Re: Bar Char + XY Chart Need Help With Inserting Dummy Line

Re: Bar Char + XY Chart Need Help With Inserting Dummy Line

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions