So if you have a large chart, you are in for a lot of clicks and manic mouse maneuvering.
At this point excel will select only one data label. You can change data labels and point them to different cells using this little trick. When you “add data labels” to a chart series, excel can show either “category”, “series” or “data point values” as data labels.īut what if you want to have a data label that is altogether different, like this:
We all know that Chart Data Labels help us highlight important data points.
