plotting 2 charts vertically one above other

[mangesh_yadav]

Is there a way in excel where you could put 2 charts vertically on
above the other in an excel chart. I dont want to use a chart with
axis as it doesn't make sense in terms of business logic. Ofcourse, th
other way is to put the charts physically in vertical direction in
worksheet.

But is there another way...?

Basically, I want to extend a vertical line from the top graph to th
one below to relate the 2 points. The x-axis is the same for both
whereas the y-axis differs.

- Manges

 

[Tushar Mehta]

For one way to do what you want see
Stacked Charts
http://www.tushar-mehta.com/excel/newsgroups/stacked_charts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Mangesh -

You could adopt this technique:

http://peltiertech.com/Excel/Charts/StackedCharts.html

It's a single chart, whereas Tushar's approach uses multiple charts. His
makes setting up each piece easier, while mine makes the X axis
alignment easier. In mine, you could adapt a technique like this:

http://peltiertech.com/Excel/Charts/AddLine.html

to add a vertical line in the chart connecting two points, or to use a
single line that runs from the top to the bottom of the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[mangesh_yadav]

First of all Thanks to both, Tushar and Jon. Well, as I had mentione
earlier, I was going to use the same method as Tushar's, but afte
going through his link, I found a lot of minute things, which woul
enhance the look-and-feel of the chart.

Now coming to Jon's method, I certainly liked it. Infact I was no
aware, one could manipulate the stacked chart type in such a beatifu
manner. I would have liked to use this method but I think it has on
drawback - we cannot plot more than one series in (say) one stack
Unless ofcourse, Jon, you have some solution for that as well !

- Manges

 

[Jon Peltier]

Mangesh -

You can plot as many line chart series wherever you want, if you use a
regular line chart type, instead of the more convenient stacked line
chart type. What puts a series within a band is the offset you add to
its scaled values. Offset zero for the bottom band, 1 for the next, ...
N-1 for the top band.

If the line or column series within a band are stacked, and maintain
their order, you can keep using the stacked types with appropriate
scaling. Clustered columns within bands are more problematic, especially
if you have unequal numbers of series within each band.

Putting lines in one band and columns in another is just a combination
line-stacked column chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______