plotting 2 charts vertically one above other

  • Thread starter Thread starter mangesh_yadav
  • Start date Start date
M

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
 
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/
_______
 
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
 
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/
_______
 
Back
Top