Creating a dynamic chart with X-axis based on days in the month

[AnneM]

Hi,

I'm hoping for some help with code for a chart, where I would like the X-axis to be dynamic, based on the number of working days in any given month.

There are four lines of data on the chart, (Target, Quotes, Orders, Invoiced) and the range for each is dependant on the Month and Holidays entered by the user in a user form. The dates themselves are in the range C6:X6 (where X is max 22 working days in the month). Other data is in rows 16, 18, 20, 22, C:X

As it is now, with a fixed date range, where there are fewer than 22 working days in the month, the lines just drop away, giving a false impression.

Can this be handled with VBA?

Many thanks in advance!

 

[AnneM]

Sorry, don't know how to delete the thread, but I have fixed the problem I had and don't want to waste anyone's time.

Thanks...