search

impcymru / impcymru-chart-formatter

A VBA module for automatically formatting various charts in Excel
0 stars 1 forks source link

With weekly data, monthly data is automatically plotted #23

Closed ImpCymru-Jessica-Pang closed 1 year ago

ImpCymru-Jessica-Pang commented 1 year ago

image

With weekly data, monthly data is automatically plotted which is not right

ImpCymru-Jessica-Pang commented 1 year ago

Is there anything for dates where you can set when to use full dates, when to use full months, when to use abb months and when to use years?

impcymru-adam-watkins commented 1 year ago

Struggling to reproduce. Is this just underlying Excel behaviour? If you change the major units of the x-axis to use months (or set it to text) then the chart formatter respects this.