itsmevic
asked on
Office 2016 - Horizontal axis is not displaying bars correctly with what my pivot table indicates
Hi, my horizontal axis in Excel 2016 is not displaying my bars correctly. Any help in getting them to reflect what my pivot table shows, is appreciated. Please see screen shot.
C--Users-vb93706-Desktop-axis---hori.JPG
C--Users-vb93706-Desktop-axis---hori.JPG
Can you upload the file rather than a screenshot?
Sorry, can't download a xlsm due to security firewall.
Can you upload a file without macros and saved as xlsx?
Can you upload a file without macros and saved as xlsx?
Your pivot table in columns Q:R is using itself as its data source.
Where should the data be coming from?
Where should the data be coming from?
ASKER
This macro basically tracks time worked on a particular task. For this spreadsheet, the macro is invoked when you click Start and stop's when you click Stop. This will then populate the time into the corresponding cell under the Time Worked column for that task. The pivot table is then updated, and the chart is then updated to show that value. The data comes from the Time Worked column.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Rob, thank you for your input. I was able to find my original macro on this and adjust it accordingly. Thank you for your input and time on this.