Log In
Register
Home
Dashboards
Power Pivot
February 18, 2017
Offline
i am trying to create a bar chart from a pivot table with information from a recently built building. The leasing started in June 2016 and went through Feb 2017. For some reason when you group by months, the pivot table takes the jan and feb 17 and puts them ahead of june-beyond 2016. It's as though it's not associating the dates with their year. I tried grouping by months and years but then you can't build a chart from that information because there are rows for "2017".
VIP
Trusted Members
June 25, 2016
Offline
Hi Paul
It will be better if you can attach an example.
Sunny
New Member
April 5, 2018
Offline
I have data table with cost data and activity. I made a dashboard by pivoting. But I don't know how to create a gantt chart using pivot with existing data sets which will make my dashboard value added. Can you help me out?
July 16, 2010
Offline
Hi Ramki,
I don't know of a way to make a Gantt chart from a PivotTable but these tutorials may help:
https://www.myonlinetraininghu.....antt-chart
https://www.myonlinetraininghu.....antt-chart
Mynda
1 Guest(s)
