• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Why would series not appear in a chart beyond a certain number of series?

R

rougeux

New Member
Helllo,


I'm working on a charting experiment that involves plotting over 100 series on a single scatter chart. The chart is fairly basic and the series are no more than 30 points each. I can add the first 54 series just fine but when I try to add the 55th or any others, they don't appear. No errors appear and the Select Data Source window shows them as added like normal. Strangely enough, they appear in the legend but not in the plot area. I understand that Excel has a limit to the number of series that can be on a chart but that's 255 and I'm nowhere near that.


I'm using Excel 2011 for Mac. Any help would be appreciated.


Regards,

Nick
 
Nick


I checked the limits of excel 2011 mac and your right it should support 255 series

http://mac2.microsoft.com/help/office/14/en-us/excel/item/91494e14-1fd0-44ff-8e76-74f3d92cfffd


Are you certain there is only 55 series?


Does your Mac have limited Ram? That could be. Reason especially if it is a Big model


Can you post your file or email me?
 
Hi Hui,


I'm sure my Mac has enough RAM. It's fairly new and nicely stocked. I've uploaded my file to my personal site temporarily and you can download it here:


http://www.c82.net/schedules.xlsx


It's essentially an attempt to create an Excel version of an interactive version I created about a year ago (http://www.c82.net/metra).


I'm plotting the columns (train lines and their schedules) and columns D through BD are showing on the chart but any series beyond BC doesn't appear. Not sure why.


Nick
 
Nick


I had no trouble adding several more series in Excel

I tried both 2010 and 2013 Windows versions


Have you tried adding the series data manually ?


Anybody else with a Excel 2010 for Mac like to try ?
 
That's pretty strange, Hui. I wonder why you were able to and I'm not. Perhaps it's an odd Mac thing? Thanks for investigating.
 
You must log in or register to reply here.
Back
Top