|
|
#1
05-22-2024, 12:50 AM
|
|||
|
|||
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: 
|
|
#2
05-22-2024, 06:40 AM
|
||||
|
||||
|
Perhaps use a Pivot Table as Data Source ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
05-24-2024, 11:48 PM
|
||||
|
||||
|
Did this help?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date Axis on line chart includes dates with no data under them, but text axis causes data to clump | jcyo233 | Excel | 6 | 10-18-2018 04:49 AM |
| X axis graph all dates when date column contains specific dates..possible ? | DBenz | Excel | 2 | 03-28-2018 04:59 AM |
| Graph - Need a second X axis on the Top of Graph | paulzy95 | Excel | 6 | 10-09-2016 12:07 PM |
 Bar Chart issue when Month Name Changes on Axis
|
randolphoralph | Excel | 4 | 05-13-2016 05:08 AM |
|
column clustered bar graph with a line graph as secondary axis
|
Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Windows 10 
Office 2019
Linear Mode
