Data labels in stacked area charts excel 2010

Kingstown_peter

New Member
Joined
May 31, 2011
Messages
3
Hi, I have a couple of stacked area charts in excel 2010 with over 400 entries on the horizontal axis, this itself is not causing a problem. However, my boss wants me to put some data labels into the chart, if I switch on the data labels they all overwrite each other and are totally illegible.
I would like to get the chart to display every tenth (for example) value as a data label. How do I go about this?
Thanks, Peter
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Hi, thanks for this suggested download, I was hoping to find a way to do this within excel itself. I work for a very large and bureaucratic organisation and trying to get the IT team to give me
privileges to load new code is a nightmare!
Peter
 
Upvote 0

Forum statistics

Threads
1,224,599
Messages
6,179,831
Members
452,947
Latest member
Gerry_F

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top