Excel--Macro to label scatter plot.

Article View: comp.apps.spreadsheets

Article #284

Back to comp.apps.spreadsheets Previous Next

#284

From: Jeff Bangert
Date: Sun, 22 Nov 1992 00:20

17 lines
962 bytes

Is it possible to write a macro which will automatically label the
points in a scatter plot?

What I would like to do is define a range which includes a column of
labels, a column of x values, and a column of y values.  Then, when
the macro is run, it would produce a scatter plot with each point
labeled with a text box.  It would be ok with me if the labels
overlapped.  I could always adjust them by hand.

Thanks for the help,

-- 
Jeff Bangert			jeff@kuhub.cc.ukans.edu
Computer Center			jeff@ukanvax.bitnet
University of Kansas
Lawrence, KS 66045
(913)864-0466

Technical Details

Message-ID: <1992Nov21.182019.45013@kuhub.cc.ukans.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!moe.ksu.ksu.edu!kuhub.cc.ukans.edu!jeff

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!zaphod.mps.ohio-state.edu!moe.ksu.ksu.edu!kuhub.cc.ukans.edu!jeff
From: jeff@kuhub.cc.ukans.edu (Jeff Bangert)
Newsgroups: comp.apps.spreadsheets
Subject: Excel--Macro to label scatter plot.
Message-ID: <1992Nov21.182019.45013@kuhub.cc.ukans.edu>
Date: 21 Nov 92 18:20:19 CST
Organization: University of Kansas Academic Computing Services
Lines: 17