Microsoft Office Forums - View Single Post - How to show month dates on axis on a graph

Thread: How to show month dates on axis on a graph

View Single Post

Old

05-22-2024, 12:50 AM

maw444

maw444 is offline

maw444 uses Windows 10

Windows 10 maw444 uses Office 2019

maw444 uses Office 2019

Office 2019

Advanced Beginner

The original poster

Join Date: Feb 2021

Posts: 40

maw444 is on a distinguished road

Default

How to show month dates on axis on a graph

I have my data on a spreadhseet. Colomn B has the dates of the year going down vertically from 1 Jan to 31 Dec on a daily basis.

My graphs show 'odd' dates. I would like them to show simply 1 Jan, 1 Feb etc (or something similar)

Examples of what I am seeing are below:

Attached Images

Graph 2.jpg (131.9 KB, 12 views)

Attached Files

Energy.xlsx (128.0 KB, 6 views)

Reply With Quote