Hello. How do I add another data label in the middle of a column that shows % over prior column?
Thanks
Hello. How do I add another data label in the middle of a column that shows % over prior column?
Thanks
? few details more ? or perhaps an attachment?
Best Regards,
Kaper
Attached sheet
Hi Ammartin,
To add the data label for %age you can follow these steps:- When you will click on chart then 2 contextual tabs will get appear, then click on Design tab, go to in the Chart layout's group, click on "Add Chart Element", where you will see the "Data Label" option when you will click on "Data Label option" then you will get drop down, from the drop down list just select "More Data Label Options". You will get a Format Data Label's dialog box where you need to click on Label options, then click on Value from cells and click on select range, whatever you will select from there you will get that as data label.
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it "
@Nisha, your suggest will only working in xl2013, which the OP does not have according to their profile.
You can still link a data label to a cell but you will either have to do it manually
http://www.andypope.info/tips/tip001.htm
or via a free addin.
http://www.appspro.com/Utilities/ChartLabeler.htm
Also I have set the base line of the chart to zero, which is how column/bar charts should be displayed.
@Andy. That works fine, but how do I have two data labels. The volume at the top and the percentage in the middle. Thanks.
Add another series and use it's data labels.
Format columns to overlap 100% and format top series to have no fill
Hello Amma,
Refer the below thread with the same requirement.
http://www.excelforum.com/excel-gene...auto-fill.html
Please let me know if it works for you too.
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
Hi Amma,
I have also attached a file for your reference. Please see if it serve your purpose.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks