In 2008 i followed youtube how to make a "dynamic gantt chart" instructions. It worked great. Now i have Excel 2013 (i think) and my chart has flat gray bars instead of 3d colored bars. What did i do wrong? Thank you, Roy
In 2008 i followed youtube how to make a "dynamic gantt chart" instructions. It worked great. Now i have Excel 2013 (i think) and my chart has flat gray bars instead of 3d colored bars. What did i do wrong? Thank you, Roy
I attached your file with added color bars and made them 3D. I'm in office 365 but it should be similar in 2013...
Right-click the bars to format > click Format Data Series... > go to the Fill section in the window or pane that opened > choose Solid fill > select a color from the options that appear. In the same window/pane that appeared, go to the Effects tab or section and you should see options for the 3D formatting.
You can also edit the formatting by clicking the chart and going to the Design tab that should have appeared when you clicked it.
Let me know if this wasn't what you were looking for!
I found what i did wrong. I had the todays date in a2 but the formula was looking for todays date in a1. It works now. Thank you for your time.