Hi -

I am trying to create a bar chart and I can only plot so many values and
then I get the following error - series formula is too long.

I have tried adding more points by holding down the control key and then
clicking on the cells I want. After about 13 values (cells) the previous cell
addresses are deleted in the Source Data - Data Range box and the flashing
dotted line around the cells disappears.

Hope someone can help.

Bob

[ExcelBanter AI]

Hi Bob,

I understand that you are facing an issue with creating a bar chart in Excel where you are getting an error message "series formula is too long" after adding a certain number of values. This error message usually occurs when the series formula exceeds the maximum limit of characters that Excel can handle.

To resolve this issue, you can try the following steps:

1. Instead of selecting the cells by holding down the control key, try selecting the entire range of cells that you want to include in the chart. You can do this by clicking and dragging the mouse over the cells.
   
2. If the above step doesn't work, you can try splitting the data into multiple series and creating separate charts for each series. To do this, select the first set of data that you want to include in the chart and create a chart. Then, select the next set of data and add it to the existing chart by right-clicking on the chart and selecting "Select Data". Repeat this process for all the sets of data that you want to include in the chart.
   
3. Another option is to use a pivot chart instead of a regular chart. Pivot charts can handle large amounts of data and can be easily filtered and manipulated. To create a pivot chart, select the data that you want to include in the chart and go to the "Insert" tab in the ribbon. Click on "PivotChart" and select the type of chart that you want to create.

I hope these steps help you resolve the issue.

try selecting the 1st cellhold down the SHIFT keyselect the last cell

--
Don Guillett
SalesAid Software

"BobY" wrote in message
...
Hi -

I am trying to create a bar chart and I can only plot so many values and
then I get the following error - series formula is too long.

I have tried adding more points by holding down the control key and then
clicking on the cells I want. After about 13 values (cells) the previous
cell
addresses are deleted in the Source Data - Data Range box and the flashing
dotted line around the cells disappears.

Hope someone can help.

Bob

There's a limit to the number of characters that you can enter in the
Data Range box.

If the cells are adjacent, drag over them to select them as one range.
If they're not adjacent, you could create a summary table on the
worksheet, linked to the discontiguous data, and create the chart from
that table.


BobY wrote:
I am trying to create a bar chart and I can only plot so many values and
then I get the following error - series formula is too long.

I have tried adding more points by holding down the control key and then
clicking on the cells I want. After about 13 values (cells) the previous cell
addresses are deleted in the Source Data - Data Range box and the flashing
dotted line around the cells disappears.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html