Values is Series

[kakarott]

I recently made a graph with 20 different values. Now i am tryin
again, but it will not allow more than 13? can some one please help.
Also after i close the graph for the first time it does the same thing
I tried making a new one, but it will not allow it

 

[Tushar Mehta]

Ummm... you need to provide some more information on the problem.

--
[Posted directly to the Usenet newsgroup -- no affiliation with
Excelforum]

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[kakarott]

I am making a graph with stats for 30 days. We have 15 different
depatments that we transfer to. For example i have a Collections dept.
I need stats for all thirty days. When i try to input all thirty
values for one series, it only allows me to type 13 values. Why? I
have entered 25 before. Excel will no longer allow me to enter more
than 13 values per series. I have tried to create a new chart and it
still only allows 13 values.
Thanks

 

[Jon Peltier]

Are the data in cells which are not connected? Every separate cell
included in a chart data range must have the sheet name prefixed to it.
Before long, the text string describing the data exceeds the
approximately 250 characters allowed for it. Try to put the data into a
single column with no spaces. To do this, copy each original cell, use
Paste Special (from the Edit menu), and click the Paste Link button.
This means the original data can stay where it is, and a formula links
to it from the new charting data range.

Now create your chart from this single worksheet range.

- Jon