Labeling data points in an Excel chart
July 8, 2014 11:35 AM Subscribe
Help me figure out how to get the labels I need on the data points in a fairly simple Y vs. X chart.
posted by ocherdraco to Computers & Internet (15 answers total) 2 users marked this as a favorite
I'm using Excel for Mac 2011, version 14.4.3.
I'm having a devil of a time figuring out how to get Excel to automatically label my data points with a value other than the X or Y value. My chart looks something like this:
Name Category Y value X value
Apple Fruit 1 2
Orange Fruit 2 4
Okra Vegetable 3 6
Beans Vegetable 4 8
I have plotted the X and Y values on a chart. I would like each data point to be labeled "Name, Category", or if only one is possible, just "Name." So, point (1,2) would be labeled "Apple, Fruit" (or just "Apple"), and point (3,6) would be labeled "Okra, Vegetable" (or just "Okra"). Is there some way I can make this happen other than by entering each label manually?