Multiple series in chart in MS Excel 2008

lmorett · lmorett #1 (**permalink**)

10-12-2009, 02:55 AM

Hi all,
I am trying to create a column graph with multiple columns for the same set of values on the x-axis (meaning, there will be 2 columns for each value on the x-axis). However, when I try to add a 2nd series within the Chart Data window (Chart>Chart Data), a message is displayed under the field for chart data range that says the following:

"The chart data range is to large to be displayed. If a new data range is selected, it will replace all of the series on the series panel."

Accordingly, when I try to select a new set of data, Excel changes the values of the columns for Series 1 to those that I am trying to select for Series 2.

Can anyone see a way around this? I don't see another option to select data on the formatting palette, and none of the other chart options seem appropriate.

A prompt response would be greatly appreciated as I am trying to figure this out for a class project that is due in 48 hrs.

Many thanks in advance for any help that you can offer.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date localisation in Excel 2008	retro83	OS X - Apps and Games	7	08-11-2010 09:35 PM
Excel 2004 Chart Default Removal	rockitdoc	Running Windows (or anything else) on your Mac	1	06-12-2009 01:45 PM
Excel 2008 Chart Trouble	jkneps	OS X - Apps and Games	0	09-16-2008 08:52 PM
Office Mac 2008 Excel Power User Question	Maggie's Farm	Switcher Hangout	0	04-03-2008 07:16 PM
Excel 2008 - Issue Creating Charts	TheAlmightySam	OS X - Apps and Games	0	03-25-2008 12:41 AM

Multiple series in chart in MS Excel 2008

Internet Services

Web Development

Digital Marketing

Consumer Tech

lmorett #1 (permalink)
Member Since: Oct 12, 2009 Posts: 1	10-12-2009, 02:55 AM Hi all, I am trying to create a column graph with multiple columns for the same set of values on the x-axis (meaning, there will be 2 columns for each value on the x-axis). However, when I try to add a 2nd series within the Chart Data window (Chart>Chart Data), a message is displayed under the field for chart data range that says the following: "The chart data range is to large to be displayed. If a new data range is selected, it will replace all of the series on the series panel." Accordingly, when I try to select a new set of data, Excel changes the values of the columns for Series 1 to those that I am trying to select for Series 2. Can anyone see a way around this? I don't see another option to select data on the formatting palette, and none of the other chart options seem appropriate. A prompt response would be greatly appreciated as I am trying to figure this out for a class project that is due in 48 hrs. Many thanks in advance for any help that you can offer.
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)