Creating Multiple Timelines on in one Chart.

%3CLINGO-SUB%20id%3D%22lingo-sub-215854%22%20slang%3D%22en-US%22%3ECreating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215854%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20multiple%20timelines%20in%20one%20Chart.%26nbsp%3B%3C%2FP%3E%3CP%3E1)%26nbsp%3B%20I%20have%20the%203%20series%20as%20three%20separate%20lines%20with%20the%20dates%20as%20a%20separate%20line%20at%20the%20bottom.%26nbsp%3B%20I%20deleted%20all%20the%20lines%20dropping%20down%20to%20the%20main%20line%2Faxis.%3C%2FP%3E%3CP%3E2)%20However%2C%20at%20some%20point%2C%20the%20dates%20at%20the%20bottom%20stopped%20reflecting%20the%20range%20I%20specified.%3C%2FP%3E%3CP%3E3)%20Also%2C%26nbsp%3B%20I%20would%20like%20the%20label%20to%20be%20the%20actual%20task%20text.%20I%20can%20only%20get%20the%20series%20name%20and%20task%20date%20to%20show.%3C%2FP%3E%3CP%3EIf%20you%20can%20assist%20in%20remedying%20these%20issues%2C%20it%20would%20be%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-215854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETutorial%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218517%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218517%22%20slang%3D%22en-US%22%3E%3CP%3ERegarding%20the%20above%20request%20for%20comments.%26nbsp%3B%20I%20found%20this%20but%20have%20not%20tried.%26nbsp%3B%20I%20have%20not%20used%20VBA%20yet%20as%20well.%20%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F764-excel-convert-cell-contents-to-comment.html%23a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F764-excel-convert-cell-contents-to-comment.html%23a1%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218515%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218515%22%20slang%3D%22en-US%22%3E%3CP%3EPerhaps%20you%20can%20help%20me%20with%20this%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20automatically%20create%20comments%20via%20a%20formula%3F%20The%20comment%20would%20be%20in%20a%20column%20of%20data%20but%20I%20would%20want%20the%20comment%20to%20appear%20elsewhere.%26nbsp%3B%20Like%20in%20the%20attached%20file%20but%20would%20like%20it%20automatic%20for%20each%20%22datapoint%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218461%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218461%22%20slang%3D%22en-US%22%3E%3CP%3EJudy%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConsultant%20-%20I'll%20ask%20Excel%20experts%20outside%20this%20forum%20if%20someone%20interesting%2C%20but%20it%20definitely%20will%20be%20paid%20consultant.%20Will%20do%20right%20now.%20Sorry%2C%20not%20for%20me%20-%20these%20activities%20for%20me%20more%20hobby%20than%20main%20job.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EMake%20labels%20viewable%20-%20I%20guess%20that's%20only%20with%20VBA%20code%2C%20but%20that's%20out%20of%20my%20expertise.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-218206%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-218206%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%202)%20and%203)%20examples%20were%20so%20simple.%20Why%20couldn't%20I%20do%20that%20on%20my%20own.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4)%20Changing%20data%20markers-%20looking%20at%20link%20and%20still%20studying%20it.%26nbsp%3B%20Not%20clear%20how%20it%20is%20done.%26nbsp%3B%20I%20really%20need%20more%20one%20on%20one%20help.%26nbsp%3B%20How%20can%20I%20find%20someone%20to%20work%20with%20me%3F%26nbsp%3B%20how%20do%20I%20find%20a%20consultant%3F%26nbsp%3B%20A%20paid%20consultant%20is%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5)%20Now%20do%20you%20have%20an%20idea%20of%20how%20to%20make%20labels%20viewable%20when%20you%20click%20on%20the%20data%20point%20or%20hover%20over%20the%20data%20point%3F%3C%2FP%3E%3CP%3EThank%20you%20-%20judy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-217031%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217031%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Judy%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20missed%20your%20previous%20post%2C%20answer%20with%20some%20delay.%3C%2FP%3E%0A%3CP%3E1)%20How%20to%20setup%20series%20depends%20on%20which%20result%20you'd%20like%20to%20have%2C%20from%20my%20point%20of%20view%20it%20looks%20okay%20now.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2)%20Scatter%20chart%20doesn't%20work%20wit%20dates%20scale%20directly%2C%20that%20will%20be%20numbers%20scale.%20The%20workaround%20could%20be%20if%20you%20add%20one%20more%20series%20with%20dates%20for%20horizontal%20axis%20and%20thread%3D0%20in%20your%20terms.%20Format%20it%20on%20chart%20as%20line%20(it'll%20be%20on%20horizontal%20access)%2C%20format%20X%20axis%20with%20dates%20as%20comfortable%20and%20finally%20make%20the%20line%20invisible.%20That's%20in%20attached%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E3)%20Yes%2C%20starting%20from%20version%202013%20you%20may%20add%20data%20labels%20from%20another%20column%20directly%20in%20Excel%2C%20I%20added%20in%20the%20attached.%20I%20know%20about%20Chart%20Labeler%20but%20never%20worked%20with%20it%20on%20practice%2C%20can't%20help%20here.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E4)%20With%20markers%20known%20workaround%20is%20to%20add%20additional%20series%20for%20which%2C%20depends%20on%20condition%2C%20value%20will%20be%20from%20the%20main%20series%20if%20you%20meet%20the%20condition%20and%20NA()%20otherwise%20(such%20will%20be%20skipped%20on%20chart)%2C%20customize%20markers%20for%20each%20such%20series.%20Idea%20is%20illustrated%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpeltiertech.com%2Fconditional-xy-charts-without-vba%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpeltiertech.com%2Fconditional-xy-charts-without-vba%2F%3C%2FA%3E%2C%20firs%20I%20found.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216256%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216256%22%20slang%3D%22en-US%22%3E%3CP%3EI%20appreciate%20any%20help%20you%20can%20give.%26nbsp%3B%20I%20have%20attached%20a%20table%20of%20data%20and%20on%20same%20sheet%202%20attempts%20at%20what%20I%20need.%26nbsp%3B%20This%20is%20in%202010%20and%20some%20issues%20might%20be%20resolved%20in%202013.%26nbsp%3B%20I%20can%20upgrade%20if%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Multiple%20line%20plots%20above%20a%20timeline.%26nbsp%3B%20%3CSPAN%3ENot%20sure%20series%20and%20primary%20and%20secondary%20axis%20are%20set%20up%20correctly%20for%20my%20needs.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E2)%20Issues%20arise%20with%20timeline%20dates%20at%20bottom.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3)I%20would%20like%20the%20data%20labels%20to%20be%20the%20descriptions.%3C%2FP%3E%3CP%3EHad%20trouble%20downloading%20Chart%20Labeler%20Add%20on.%26nbsp%3B%20Though%20I%20have%20seen%20a%20tutorial%20that%20does%20what%20I%20need%20for%20the%20labels.%26nbsp%3B%20However%20my%20set%20up%20is%20not%20quite%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4)I%20also%20would%20like%20to%20import%20custom%20markers.%20My%20full%20database%20has%20many%20custom%20markers.%26nbsp%3B%20In%20this%20example%20I%20just%20chose%20some%20symbols.%26nbsp%3B%20The%20symbols%20in%20the%20marker%20column.%26nbsp%3B%20I%20don't%20want%20the%20automatic%20markers%20and%20I%20don't%20want%20to%20put%20in%20custom%20markers%20one%20by%20one.%26nbsp%3B%20which%20I%20know%202010%20let's%20me%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%202010%20or%202013%20won't%20allow%20me%20to%20pull%20in%20custom%20markers%20automatically.%26nbsp%3B%20I%20have%20been%20thinking%20maybe%20I%20could%20use%20a%20data%20label%20filled%20with%20the%20custom%20marker.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-215931%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Multiple%20Timelines%20on%20in%20one%20Chart.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-215931%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Judy%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20first%20two%20it'll%20be%20better%20if%20you%20attach%20small%20sample%20file%20which%20illustrates%20what%20doesn't%20work.%3C%2FP%3E%0A%3CP%3EFor%20the%20third%20one%20the%20workaround%20could%20be%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Fchange-data-labels-in-charts%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchandoo.org%2Fwp%2Fchange-data-labels-in-charts%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I am creating multiple timelines in one Chart. 

1)  I have the 3 series as three separate lines with the dates as a separate line at the bottom.  I deleted all the lines dropping down to the main line/axis.

2) However, at some point, the dates at the bottom stopped reflecting the range I specified.

3) Also,  I would like the label to be the actual task text. I can only get the series name and task date to show.

If you can assist in remedying these issues, it would be much appreciated.

 

 

 

7 Replies
Highlighted

Hi Judy,

 

For first two it'll be better if you attach small sample file which illustrates what doesn't work.

For the third one the workaround could be https://chandoo.org/wp/change-data-labels-in-charts/

 

Highlighted

I appreciate any help you can give.  I have attached a table of data and on same sheet 2 attempts at what I need.  This is in 2010 and some issues might be resolved in 2013.  I can upgrade if needed.

 

1) Multiple line plots above a timeline.  Not sure series and primary and secondary axis are set up correctly for my needs.

 

2) Issues arise with timeline dates at bottom.

 

3)I would like the data labels to be the descriptions.

Had trouble downloading Chart Labeler Add on.  Though I have seen a tutorial that does what I need for the labels.  However my set up is not quite the same.

 

4)I also would like to import custom markers. My full database has many custom markers.  In this example I just chose some symbols.  The symbols in the marker column.  I don't want the automatic markers and I don't want to put in custom markers one by one.  which I know 2010 let's me do.

 

If 2010 or 2013 won't allow me to pull in custom markers automatically.  I have been thinking maybe I could use a data label filled with the custom marker. 

 

Highlighted

Hi Judy,

 

Sorry, I missed your previous post, answer with some delay.

1) How to setup series depends on which result you'd like to have, from my point of view it looks okay now.

 

2) Scatter chart doesn't work wit dates scale directly, that will be numbers scale. The workaround could be if you add one more series with dates for horizontal axis and thread=0 in your terms. Format it on chart as line (it'll be on horizontal access), format X axis with dates as comfortable and finally make the line invisible. That's in attached file.

 

3) Yes, starting from version 2013 you may add data labels from another column directly in Excel, I added in the attached. I know about Chart Labeler but never worked with it on practice, can't help here.

 

4) With markers known workaround is to add additional series for which, depends on condition, value will be from the main series if you meet the condition and NA() otherwise (such will be skipped on chart), customize markers for each such series. Idea is illustrated here https://peltiertech.com/conditional-xy-charts-without-vba/, firs I found.

Highlighted

Sergei -

 

Your 2) and 3) examples were so simple. Why couldn't I do that on my own.

 

4) Changing data markers- looking at link and still studying it.  Not clear how it is done.  I really need more one on one help.  How can I find someone to work with me?  how do I find a consultant?  A paid consultant is fine.

 

5) Now do you have an idea of how to make labels viewable when you click on the data point or hover over the data point?

Thank you - judy

Highlighted

Judy,

 

Consultant - I'll ask Excel experts outside this forum if someone interesting, but it definitely will be paid consultant. Will do right now. Sorry, not for me - these activities for me more hobby than main job.

 

Make labels viewable - I guess that's only with VBA code, but that's out of my expertise.

Highlighted

Perhaps you can help me with this one.

 

Can I automatically create comments via a formula? The comment would be in a column of data but I would want the comment to appear elsewhere.  Like in the attached file but would like it automatic for each "datapoint".

 

Thank you.

 

 

 

Highlighted

Regarding the above request for comments.  I found this but have not tried.  I have not used VBA yet as well. https://www.extendoffice.com/documents/excel/764-excel-convert-cell-contents-to-comment.html#a1