How do i make two column graphs into one? on one axis
Help please
I want to plot data from two colum graphs on one axis, one vertically above the other. The y axis doesn't need to start at 0 again, just continue on from the one below. Anyone know ? |
How do i make two column graphs into one? on one axis
That's a stacked column chart. Select all the data and create a new chart
using this chart type, or take one of the single series charts, copy the other data, select the chart, and use Paste Special (Edit menu) to add the data as a new series. Then go to the Chart menu Chart Type, and choose the stacked column chart type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "becks" wrote in message ... Help please I want to plot data from two colum graphs on one axis, one vertically above the other. The y axis doesn't need to start at 0 again, just continue on from the one below. Anyone know ? |
How do i make two column graphs into one? on one axis
Ok probably needed to add more information. I really want to put the
information from both charts on the one axis but seperated. so theres a normal column graph and the y axis just continues going up then another group of columns higher with a gap in between them and the ones below! So there could be another xaxis line there with no labels. So say the bottom columns go to 20,000 , then the top columns would all start at 25000. Do i need to make a stacked column then blank out the the middle stack? "Jon Peltier" wrote: That's a stacked column chart. Select all the data and create a new chart using this chart type, or take one of the single series charts, copy the other data, select the chart, and use Paste Special (Edit menu) to add the data as a new series. Then go to the Chart menu Chart Type, and choose the stacked column chart type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "becks" wrote in message ... Help please I want to plot data from two colum graphs on one axis, one vertically above the other. The y axis doesn't need to start at 0 again, just continue on from the one below. Anyone know ? |
How do i make two column graphs into one? on one axis
Do i need to make a stacked column then blank out the the middle stack?
Yep. Not hard, just use =25000-B2 to get the value of the invisible bar. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "becks" wrote in message ... Ok probably needed to add more information. I really want to put the information from both charts on the one axis but seperated. so theres a normal column graph and the y axis just continues going up then another group of columns higher with a gap in between them and the ones below! So there could be another xaxis line there with no labels. So say the bottom columns go to 20,000 , then the top columns would all start at 25000. Do i need to make a stacked column then blank out the the middle stack? "Jon Peltier" wrote: That's a stacked column chart. Select all the data and create a new chart using this chart type, or take one of the single series charts, copy the other data, select the chart, and use Paste Special (Edit menu) to add the data as a new series. Then go to the Chart menu Chart Type, and choose the stacked column chart type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "becks" wrote in message ... Help please I want to plot data from two colum graphs on one axis, one vertically above the other. The y axis doesn't need to start at 0 again, just continue on from the one below. Anyone know ? |
All times are GMT +1. The time now is 01:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com