i would like to format a series of

[jillseurre]

i would like to format a series of data to chart,

series1
series2
series3

series 1 & 2 formatted as a stack graph
series 3 as a line on the graph

any help please

 

[SkipVought]

Hi,

Select the series.

Manu Item - Chart/Chart Type and select the type

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jillseurre]

cant find a stacked/line graph combined

 

[SkipVought]

You can select the chart type for each series.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jillseurre]

sorry must be missing something obvoius - cant select chart type for each series

officeXP

dataset 1 d2.d10 = bottom of stack graph
Numbers range 0-10,000
dataset 2 e2.e10 = top of stacked graph
Numbers range 0-10,000
no problem done

dataset 3 f2.f10 = a line with a 2nd scale
numbers 0 - 6.4

 

[SkipVought]

well 1 & 2 are the SAME chart type -- stacked column

3 is a line chart

What's the problem?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jillseurre]

still very lost, I want i graph which has a stacked graph on it and a line graph on it,

25 |Z z . 5
20 |Z z x 4
15 |x. z z. x 3
10 |x x. z x 2
5 |x x x x 1
0 |---------------------0

X - series 1 bottom of stack
Z - series 2 top of stack
. - series 3 line graph @ different scale

 

[SkipVought]

Tell me what is not working? Did you format 1 & 2 as a stacked column and 2 as a line chart?

With the line series, format the series axis tab - plot on secondary axis.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

BTW, a SERIES is IN a CHART. The corresponding source data is a RANGE.

I am assuming that you have used the chart wizard to create you chart WITH ALL 3 SERIES, by selecting the stacked column type.

THEN, you select the third SERIES and do the steps as outlined above.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[jillseurre]

thanks, i got it now, didnt realise you could selectively format ranges, not intuative

 

[SkipVought]

Once a chart has been created, you can COPY a RANGE of new data, SELECT the chart and Edit/Paste Special to create a new SERIES.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com