[Solved] Chart with very different data series

[metalchrist]

Hello, people. i would like to know if a chart with this aspect is possible to make in OOo Calc.

http://img254.imageshack.us/img254/5594/graficadk0.jpg

I want the smaller data series to be shown too.

Thank u very much!

Edit: Hagar: uploaded the pic on the site so it's kept even after imageshack time limit is over.

[acknak]

You can plot the data sets against two independent Y-axes.

You can't have a single Y-axis that has a break in it, as shown in your example.

[metalchrist]

But is it possible to have 2 different Y axis in the same chart? I would like to have all the data series in the same chart, not in 2 independent charts...

If it is not possible, is there any way to show the low value data series?

[acknak]

Sure, with some limitations.

Maybe the biggest problem is that it's not so clear that which data are plotted against which axis.

If you have time, you can copy/paste a chart into Draw and do anything you like to it. Once you do that, it's no longer a chart, it's just a drawing, but it can be handy for the final tweaks. You can keep the original chart too, of course.

Here's about the best I could do using Chart alone (top), and after tweaking it (~5 minutes) in Draw:


Document: chart_break.odg

[metalchrist]

Thank you very much, i think that is the best solution.

I hope this capability is implemented in OOo Calc future versions. It will be a very good point, because we are a lot of people who use that strange kind of charts.

Thank u.