Adding data label and editing x-axis label

A

AS000

New Member
Joined
Jan 11, 2023
Messages
1
Office Version
  1. 365
  2. 2019
Platform
  1. MacOS
Hi, I'm creating a tidal graph using a line graph and have two quick questions on data/axis labels...

Question 1- How to add the time to the data labels, so it displays the height (column B) & time (column C) for each point stacked on a new line? It's currently automatically displaying only the height.

Question 2 - How to only show the date along the x-axis (column A)? It's currently automatically displaying the time & date.

Graph.png


This is what the data looks like...

Data.png


Any help would be great!!

Thanks.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
You must log in or register to reply here.

Similar threads

O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
338
OrangeJuice
O
A
  • Question
Help Debugging Custom Data Label Macro
Replies
0
Views
140
arndtea
A
N
  • Solved
Line chart only showing 4 dates on X-Axis
Replies
3
Views
245
awoohaw
awoohaw
G
  • Question
bubble chart with multiple series
Replies
0
Views
652
Glainer
G
P
  • Question
Excel Line graph - Y axis issues - seems to be summing the data
Replies
2
Views
163
panesai1
P

Forum statistics

Threads
1,215,064
Messages
6,122,942
Members
449,094
Latest member
teemeren

Share this page

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