Bar Graph Structure incorrect after Macro

Originally Posted by dflak

Forget the VBA and go with Excel Tables. I converted your data range in columns B:D into an Excel table. Tables have several advantages:

1. They know how big they are, so formulas, pivot tables and charts built off them always reference the right amount of data.
2. They remember and copy down formulas, formats, validations, etc. automatically.

I added a helper column for Month.

I overlaid the table with named dynamic ranges:
Plot_Calls =OFFSET(Plot_Date,0,1)
Plot_Chat =OFFSET(Plot_Date,0,2)
Plot_Date =OFFSET(X!$B$68,0,0,COUNTA(X!$B:$B)-1,1)

I used these dynamic ranges as the data sources for the chart.

Here are a couple of wikis that describe named dynamic ranges and how to use them in charts:
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
http://www.utteraccess.com/wiki/Dynamic_Charting

Finally I added a slicer to the table (do a web search on them - they are fancy filters that are easy to implement and are very powerful).

All of this is built-in Excel.

P.S All you have to do is add in the next date (12/27/2018) on the next line in the table and the formulas in Columns C and E will be replicated automatically and the dynamic range will add the date to the end of the chart.

I'm not sure how to word this but I have a Macros (one for each Month of the Year) that are used to inform a Graph's Data. They are Structured exactly the same, the only thing that changes are the Cells they reference. It works Great for the OCT and NOV Macros, however past that, the Bar Graph is interperetting the data incorrectly.

EXAMPLE:
NOVEMBER (CORRECT)

Please Login or Register  to view this content.

NOV CORRECT.PNG


DEC INCORRECT

Please Login or Register  to view this content.

DEC INCORRECT.PNG

Any Advice would me very much appreciated! Thank you!

Absent a workbook, I'd just suggest you explicitly set the values and xvalues for the 2 series in the chart instead of use setsourcedata.