AndrewRoach97
New Member
- Joined
- Jan 10, 2019
- Messages
- 1
Hey guys
So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different variables that the person enters. i.e the person using the graph picks their age, weight and other variables like that from dropdwn boxes and based on those selections excel will plot certain series. Due to the number of variables from the dropdown boxes that the person can pick from, there will end up being over 500+ series that can be plotted. Is 255 the maximum number of series that can be plotted at once or is it the maximum number of series whether they are plotted on the graph or not?
So i know that 255 is the maximum number of series that excel can plot. However would excel be able to plot more than 255 series on a graph but only having 7 or so displayed at one time? I am trying to make a dynamic chart that changes what series are plotted based on different variables that the person enters. i.e the person using the graph picks their age, weight and other variables like that from dropdwn boxes and based on those selections excel will plot certain series. Due to the number of variables from the dropdown boxes that the person can pick from, there will end up being over 500+ series that can be plotted. Is 255 the maximum number of series that can be plotted at once or is it the maximum number of series whether they are plotted on the graph or not?
