I am using an access database to populate a Word template with chart data. I am using 13 month rolling data, however some months have no value, but i still want this to be displayed in the chart and it is not, it just skips the month any ideas how i would do this? Very new to VBA