Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2017, 01:22 PM
petermikula petermikula is offline Stacked Bar chart date issue Windows 10 Stacked Bar chart date issue Office 2016
Novice
Stacked Bar chart date issue
 
Join Date: Feb 2017
Posts: 2
petermikula is on a distinguished road
Default Stacked Bar chart date issue

I'm using a project mgmt excel dashboard which included a stacked bar chart. The template had dates from 2015, I"m using it for project which has dates from 2017 on. The chart still "thinks" it needs to show on the axis 2015 dates which makes the gannt chart inaccurate . However the data source does not have any 2015 tasks. I tried different things but looks to me like a bug or something.

I have attached a sample

Please advise how to fix the gantt chart that pulls data from the notes table

Thanks a lot!



Peter
Attached Files
File Type: xlsx Project Management Dashboard Template - Copy.xlsx (34.5 KB, 2 views)
Reply With Quote
  #2  
Old 02-21-2017, 05:01 PM
jeffreybrown jeffreybrown is offline Stacked Bar chart date issue Windows Vista Stacked Bar chart date issue Office 2007
Expert
 
Join Date: Apr 2016
Posts: 628
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

It looks like it might have to do with your axis.

Right click on the axis in the gantt chart and format axis.

Notice the minimum value is set to fixed, 42249, with is equal to the date 9/2/2015
------------------------------------------------------------------------------
And, on your gantt chart data, I would probably only graph down thru row 14, not row 15
Reply With Quote
  #3  
Old 02-21-2017, 05:48 PM
petermikula petermikula is offline Stacked Bar chart date issue Windows 10 Stacked Bar chart date issue Office 2016
Novice
Stacked Bar chart date issue
 
Join Date: Feb 2017
Posts: 2
petermikula is on a distinguished road
Default

thanks, that did it!
Reply With Quote
  #4  
Old 02-21-2017, 05:55 PM
jeffreybrown jeffreybrown is offline Stacked Bar chart date issue Windows Vista Stacked Bar chart date issue Office 2007
Expert
 
Join Date: Apr 2016
Posts: 628
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Happy to hear you have a workable solution now. You're welcome.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Bar chart date issue Change Date Format in Gantt Chart culverjack Visio 2 11-08-2016 08:12 AM
Stacked Bar chart date issue Bar Chart issue when Month Name Changes on Axis randolphoralph Excel 4 05-13-2016 05:08 AM
Excel Dashboard: Attempt to integrate Boxplot (clusted bar chart) into KPI Display (stacked bar) Confused_Robin Excel 0 11-02-2015 12:30 PM
How to add data label individually in a stacked-bar chart? officeboy09 Excel 0 10-17-2013 01:26 AM
move to first date on gantt chart etsoft Project 3 12-23-2011 08:32 AM

Other Forums: Access Forums - Senior Forums

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


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