scatter plot x versus y but showing data point lables form another column

Topic

New Reply

I wish to make an xy scatter plot of the incident cases per 100 000 versus an estimation of number of persons exposed and using the region number as the data point lable. I know of a macro solution but surely there must be an easier way in office 2010 or 2013 http://support.microsoft.com/kb/213750

exposed casesper100000 region
8700 102.56 01
14800 137.76 02
17300 62.43 03
22300 154.84 04
14400 95.51 05
51000 15.69 06
9200 83.15 07
8400 71.66 08
5300 201.86 09
2900 68.52 11
18000 128.21 12
8600 28.78 13
21700 55.67 14
19200 44.07 15
63400 46.50 16

Reply | Quote

Replies

MS MVP Rob Bovey’s Free Addin at http://www.appspro.com/Utilities/ChartLabeler.htm is what I use to do this

[The lack of this feature in XL has been a pet peeve of mine since I moved away from Lotus 123 in the mid-90s. Lotus 123 also had an addin which allowed formatting parts of a cell containing a formula. Excel still has neither of these (for me) very useful features. Bovey’s Addin at least solves one of my peeves…]

Steve

Reply | Quote