<div>
Hello,<br />
<br />
I've removed the gradient background and the 3D effect to make the chart easier to read.<br />
<br />
1. Create two text boxes above the columns, select each text box in turn, enter a = sign into the formula bar and click the cell in the table that holds the total value for that column.<br />
<br />
2. Only pie charts calculate percentages automatically. For all other charts, you need to provide the calculations in the sheet. I've created two column with formulas to do that. I've then used a free Add-in called XY Chart Labeler to add the percentages as data labels in the chart. The Add-in can be downloaded here: <a href="http://www.appspro.com/Utilities/ChartLabeler.htm" rel="ugc">http://www.appspro.com/Utilities/ChartLabeler.htm</a><br />
<br />
3. Separate the totals row by at least one empty row from the data table. Turn on autofilter and use the drop-downs in the table headers to sort whichever way you like.<br />
<br />
See attached.<br />
<br />
cheers, teylyn<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/10_w42/510913/Column-Chart.xlsx" target="_blank" class="file-inline" title="chart (198 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Column-Chart.xlsx</a>
</div>


Column-Chart.xlsx

<div>
Thanks, teylyn.<br />
<br />
1. &nbsp;Got this one. &nbsp;But how can format the text in the text box? &nbsp;For example, the number is $100.9M instead of 100.9. &nbsp;I try using the TEXT formula but it didn't work.<br />
<br />
2. &nbsp;I found this add-in on the web. &nbsp;It works perfectly<br />
<br />
3. &nbsp;I try autofilter but the chart doesn't follow exactly the order displayed in the data source.
</div>


<div>
<div class="content wysiwyg-content">
Hi, I have created a column chart (attached) and I want to add the following:<br />
<br />
1. Total on the top of each column<br />
2. % mix of each data label (I know I can do it with a pie chart but I can't find the option to do it here).<br />
3. &nbsp;Sort the column and data table either base on alphabetical order or ascending value.<br />
<br />
I appreciate your help. &nbsp;Thanks.<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/10_w42/510876/Column-Chart.xlsx" target="_blank" class="file-inline" title="column chart (195 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Column-Chart.xlsx</a>
</div>
</div>


Hi, I have created a column chart (attached) and I want to add the following:

1. Total on the top of each column
2. % mix of each data label (I know I can do it with a pie chart but I can't find the option to do it here).
3.  Sort the column and data table either base on alphabetical order or ascending value.

I appreciate your help.  Thanks.

Excel 2007-Column Chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.