Q: How to add multiple data labels to one chart series in Excel?
A: Excel does not support multiple data labels by itself. But you can create a duplicated series for the target series and then change the duplicated one's chart type to "scatter chart without markers". It looks like there are two data labels for that series if you enable the data label for the new scatter chart.
We've post an article about table style chart. Some friends drop us mail how to replace the bars in that table with pie charts. It's difficult to do that directly in Excel. But we can use vector image to simulate it. Today, we will practice this technology. The following example comes from a popular IT magazine. We will create left part of it.
Office 2007 and Office 2010 enhance the processing for vector image, especial for windows media file (Wmf). Powerpoint can save any chart as wmf file, which is not supported by Excel. So this time, we will use Powerpoint as charting tool.
1. Duplicate Data source to create an enlarged pie to emphasize a special data series.
2. Duplicate Data source to create the second edge for a pie chart.
In Excel, we usually explode one pie from the whole pie chart to emphasize a special data series. But I also find a different solution, which enlarges that pie and highlight data series by size. The left of the following picture is the normal scenario and the right one is a different one. (Please see the green arrow!)
Dynamic chart is another important topic in Excel. We summarize our daily reports and find 5 useful tips on this area. Hope it's useful in your work. This post is the first one and it's about "how to use auxiliary column to create a dynamic pie chart". In fact, we've used this technology in our previous post. If you've read "Square Pie Chart", you might find we use a spin control to change the percentage value. Spin control binds to a cell and the cell determinates the result chart.