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

AnneM

New Member
Joined
Nov 13, 2015
Messages
27
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!
 

Attachments

  • Screenshot 2023-07-14 at 15.09.20.png
    Screenshot 2023-07-14 at 15.09.20.png
    21.8 KB · Views: 11

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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...
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top