#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
thanks, that did it!
|
#4
|
|||
|
|||
Happy to hear you have a workable solution now. You're welcome.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Date Format in Gantt Chart | culverjack | Visio | 2 | 11-08-2016 08:12 AM |
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 |