Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

scatter graphs excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scatter Graphs in Excel

Scatter Graphs in Excel

ResolvedVersion 2003

mark has attended:
Excel Advanced course

Scatter Graphs in Excel

I am trying to create a scatter graph with two numerical data series acting as coordinates on the graph. However, I also need to include data labels for each point on the graph. So far I have not been able to do this, is it possible?

Thanks

RE: Scatter Graphs in Excel

Hi Mark,
Thank you for your question:
In response; I can only assume you have been able to create the scatter graph using the Chart Wizard; if so adding the data labels should follow the sequence: select the chart by clicking in the Chart area, from the menu command choose the Chart>Chart Options>Data Labels and choose X or Y or both.. I hope that helps ..Pete

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.