Change horizontal axis to first day of the month

tigger_oz

New Member
Joined
Dec 9, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
AXIS values
I'm hoping someone can assist. I have a bar chart and want the horizontal access lines to represent first day of each month.
When I right click horizontal axis to format axis, I don't have the option to change min & max bounds to dates/months as in start 01/10/21, and end 30/06/22 as suggested in another thread - there's only numbers.
Major & minor options are set to 31.0/major and 7.0/minor but as there aren't a standard 31 days p/month I can't get the axis dates to reflect 01/01, 01/02, 01/03, etc.
Under Axis Options/Number - I have changed category to 'custom' and added the type & format code to 'dd/mm'.
I'm sure there's an easy answer but I can't seem to find it!

Automatic Colour Coding of Bars in Bar Graph
In the same spreadsheet, I'm trying to automatically colour code the bars in the bar graph according to team. If my colleagues add or remove lines, I'm currently reformatting the bars in the graph manually to match the colour I've allocated to their team. Is there a way to automate the colour coding, I have used a free excel template online, which has some sort of auto colour coding in it but I can't work out how to change it.
 

Attachments

  • Help1.JPG
    Help1.JPG
    101 KB · Views: 29
  • Help2.JPG
    Help2.JPG
    81.2 KB · Views: 29
  • Help3.JPG
    Help3.JPG
    30.6 KB · Views: 29

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,215
Messages
5,836,055
Members
430,403
Latest member
RoToR

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
Top