G Gerry Mar 23, 2004 #1 Is it possible to create a stacked Column and line axis Chart? Stacked column from 3 rows of data. & Line from 1 row of data?
Is it possible to create a stacked Column and line axis Chart? Stacked column from 3 rows of data. & Line from 1 row of data?
D Debra Dalgleish Mar 23, 2004 #2 Create a stacked column chart from all the data Right click on the series that you want as a line. Choose Chart Type Select a Line chart, click OK
Create a stacked column chart from all the data Right click on the series that you want as a line. Choose Chart Type Select a Line chart, click OK
A Andy Pope Mar 23, 2004 #3 Hi Gerry, Yes it should be possible. Start by selecting all the data and creating a stacked column. Now select the data series that you want to plot as a line. Right click and choose Chart Type. Pick the required line type. Cheers Andy
Hi Gerry, Yes it should be possible. Start by selecting all the data and creating a stacked column. Now select the data series that you want to plot as a line. Right click and choose Chart Type. Pick the required line type. Cheers Andy
G Gerry Mar 23, 2004 #4 My thanks to the heroes...is always the same when the boss wants something in a hurry. Cheers
G Gerry Mar 23, 2004 #5 My thanks to the heroes...is always the same when the boss wants something in a hurry. Cheers
G Guest May 14, 2004 #6 Yes, create as you would for a stacked column graph, then right mouseclick on the series you want changed to a line and change the chart type.
Yes, create as you would for a stacked column graph, then right mouseclick on the series you want changed to a line and change the chart type.