Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2017, 07:57 PM
SteMob SteMob is offline Gantt Chart Help Windows 7 64bit Gantt Chart Help Office 2013
Novice
Gantt Chart Help
 
Join Date: Feb 2017
Posts: 1
SteMob is on a distinguished road
Default Gantt Chart Help


Hello,

I am working on a Gantt Chart. I was using a template, but now when I try to add additional tasks and dates, it will not add them. Attached is my spreadsheet.

If anyone can offer any advice or help, I would greatly appreciate it.
SM
Attached Files
File Type: zip Gantt Chart RevB.zip (86.8 KB, 11 views)
Reply With Quote
  #2  
Old 02-04-2017, 06:41 AM
xor xor is offline Gantt Chart Help Windows 10 Gantt Chart Help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Activate the chart.
Right click and Select Data.
Choose Start and press Edit.
Change the Series Values reference as required.
OK.

Same procedure for Duration.

If you un-merge row 3 and 4, put your headings in B4:E4 and make B4:E24 an Excel Table the chart will automatically adjust in case of more tasks.
Reply With Quote
Reply

Tags
bar chart, gantt, gantt chart

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gantt Chart Help Roll Up Summary Name does not appear on gantt chart dnantia Project 3 02-13-2016 12:30 PM
Gantt Chart Help Gantt Chart hdlarrain Excel 1 12-13-2015 03:13 AM
Gantt Chart Help Removing the Gantt chart from a view raminraiszadeh Project 3 02-13-2015 01:24 PM
Excel Gantt Chart Help kpk250 Excel 0 03-08-2013 08:46 AM
Bar in the Gantt chart with the duration ms_user Project 3 01-11-2013 06:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:06 AM.


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