Office 2016 - Horizontal axis is not displaying bars correctly with what my pivot table indicates

itsmevic
itsmevic used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rob HensonFinance Analyst

Commented:
Can you upload the file rather than a screenshot?
Rob HensonFinance Analyst

Commented:
Sorry, can't download a xlsm due to security firewall.

Can you upload a file without macros and saved as xlsx?
Rob HensonFinance Analyst

Commented:
Your pivot table in columns Q:R is using itself as its data source.

Where should the data be coming from?
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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.
Finance Analyst
Commented:
That's what I thought.

See attached amended file. I have the changed the source of the pivot table to range A3:M20

However, pivot tables must have headers in all columns and columns C to L have no headers, I have just added a space in each, I assume your real file will have proper headers.
C--Users-vb93706-Desktop-Task-vs-Ti.xlsx

Author

Commented:
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial