Leading the way in Microsoft Office Development

Pie Charts - Limited data labels

When you create a pie chart with the labels and percentages displayed next to each segment there is sometimes not enough room.

The width of each label is fixed and is sometimes not wide enough to display the label in full.

A way round this problem is to convert all the labels to text boxes meaning that the width is not fixed and can be adjusted accordingly.

Line Charts - Displaying an unlimited number of data points on

You should actually use an XY scatter chart instead of a line chart. Set up the data with the dates in one column and values in another as usual. Highlight the first block of data (up to 454 rows).

Create an XY scatter chart and choose to plot lines only, no markers.

Then select the next block of data and copy the selection to the clipboard.

Activate the chart, choose Paste Special and choose “New Series”, Values in Columns Categories (X Values) in first column. Repeat this step for an much data as you have.

Bubble Charts - Placing your data labels in a sensible position

General - Adding a single vertical line

There are two ways:

Change the point at which the value(Y) axis crosses the axes. You can specify the exact value or date in Chart Options.

You can also add a new series as column chart. You need to add an additional data series and then lace values the same as the maximum scale.

General - Adding additional labels and comments

If inserting additional text boxes, ensure that the chart is selected first, otherwise the textbox will be floating over the top as opposed to in the chart.

General - Charting dynamic data over a period containing some #N/As

Plot the chart as normal including the full range (so including the #N/As). #N/As are not actually plotted by the chart so there should be a gap in your chart. In order to remove the gap just change the minimum date value for the x-axis to be the first da

General - Missing X axis labels

If a chart axes will not display a 2000 then you can change the axis type from Time Series to Category and change the “number of categories between tick marks”