Create a 3D stacked graph?

Shane · Apr 9th, 2002, 05:14 AM

Hi there. I'm trying to create a stacked graph for each of the 12 months of 2002 with data for the corresponding months of 2001 stacked in the background, i.e. 2002 monthly sales revenues by product with the 2001 monthly figures in the background.

Although Excel will allow me create stacked graphs and, separately, will allow me create a 3D graph comparing data across categories and across series, it will not allow me - as far as I know - do both in one graph.

If you have any idea how I may be able to do this, I'd be grateful!

SamS · Apr 9th, 2002, 05:34 AM

Quote:

On 2002-04-09 04:14, Shane wrote:
Hi there. I'm trying to create a stacked graph for each of the 12 months of 2002 with data for the corresponding months of 2001 stacked in the background, i.e. 2002 monthly sales revenues by product with the 2001 monthly figures in the background.

Although Excel will allow me create stacked graphs and, separately, will allow me create a 3D graph comparing data across categories and across series, it will not allow me - as far as I know - do both in one graph.

If you have any idea how I may be able to do this, I'd be grateful!

Shane, This has been asked many times and I haven't seen it answered yet (may have missed it though). My thoughts are that a stacked graph is exactly that, otherwise it wouldn't be called a Stacked Graph. I hope somebody can prove otherwise.

Sam

Shane · Apr 9th, 2002, 05:42 AM

Thanks Sam. Is it then the case that Excel will only allow such graphical foreground-background comparisons with the most basic sets of data? i.e. compare the 2002 monthly values for one product with the corresponding months in 2001?

SamS · Apr 10th, 2002, 03:31 PM

Shane, I have been able to get around such limitations by using a second Y axis and setting the gap width of Y1 axis to 150 and Y2 axis to 300. But this only works for columns and not Stacked charts for which I have a need. Most times this question has been raised there hasn't been a response so I think it can't be done.

Shane · Apr 10th, 2002, 04:05 PM

Fair enough Sam. Thanks for the advice!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 05:14 AM	#1
Shane Board Regular Join Date: Apr 2002 Location: Dublin, Ireland Posts: 51	Hi there. I'm trying to create a stacked graph for each of the 12 months of 2002 with data for the corresponding months of 2001 stacked in the background, i.e. 2002 monthly sales revenues by product with the 2001 monthly figures in the background. Although Excel will allow me create stacked graphs and, separately, will allow me create a 3D graph comparing data across categories and across series, it will not allow me - as far as I know - do both in one graph. If you have any idea how I may be able to do this, I'd be grateful!

Apr 9th, 2002, 05:42 AM	#3
Shane Board Regular Join Date: Apr 2002 Location: Dublin, Ireland Posts: 51	Thanks Sam. Is it then the case that Excel will only allow such graphical foreground-background comparisons with the most basic sets of data? i.e. compare the 2002 monthly values for one product with the corresponding months in 2001?

Apr 10th, 2002, 03:31 PM	#4
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	Shane, I have been able to get around such limitations by using a second Y axis and setting the gap width of Y1 axis to 150 and Y2 axis to 300. But this only works for columns and not Stacked charts for which I have a need. Most times this question has been raised there hasn't been a response so I think it can't be done.

Apr 10th, 2002, 04:05 PM	#5
Shane Board Regular Join Date: Apr 2002 Location: Dublin, Ireland Posts: 51	Fair enough Sam. Thanks for the advice!