Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2015, 09:11 AM
MicrosoftNovice2015 MicrosoftNovice2015 is offline Excel 2013 Project Timeline - colour coding data labels Windows 8 Excel 2013 Project Timeline - colour coding data labels Office 2013
Novice
Excel 2013 Project Timeline - colour coding data labels
 
Join Date: Sep 2015
Posts: 1
MicrosoftNovice2015 is on a distinguished road
Default Excel 2013 Project Timeline - colour coding data labels


I've created a timeline using the Excel 2013 Project Timeline template. Is there any way to colour code the Milestone data fonts in the Project Details Table so that it automatically updates the Data Labels on the timeline to the same colour? Simply changing the font colour in the table doesn't do it. I can change the individual labels manually but if I then insert an additional row in the table, it throws all my label colours out of sequence and my labels end up in the wrong font colours. Is it possible? Thanks
Reply With Quote
  #2  
Old 09-15-2015, 02:16 PM
trainingclc trainingclc is offline Excel 2013 Project Timeline - colour coding data labels Windows 10 Excel 2013 Project Timeline - colour coding data labels Office 2013
Novice
 
Join Date: Sep 2015
Location: Houston, TX
Posts: 16
trainingclc is on a distinguished road
Default

Have you tried conditional formatting?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Dynamic Timeline in Powerpoint with data from Excel table Kostas_S PowerPoint 0 09-02-2015 03:25 AM
Excel 2013 Project Timeline - colour coding data labels Excel 2013 Graphs automatically aligning data labels to end of bar katm3 Excel 7 08-06-2015 04:36 PM
Linking/Assigning Excel data 2 shapes (Timeline functionality) mediaset23 Visio 0 07-31-2015 04:18 AM
Linking Excel Data t oa Visio Timeline Glen3den Visio 0 06-18-2015 06:11 AM
Project 2013 - Change GANTT Bar Colour By Main Task Date CaelanT Project 1 02-09-2015 12:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:12 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft