Page 1 of 1

[Solved] Chart with very different data series

PostPosted: Fri Jan 25, 2008 7:11 pm
by 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
graficadk.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. 

Re: Chart with very different data series

PostPosted: Fri Jan 25, 2008 8:08 pm
by 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.

Re: Chart with very different data series

PostPosted: Fri Jan 25, 2008 8:35 pm
by 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?

Re: Chart with very different data series

PostPosted: Fri Jan 25, 2008 10:10 pm
by 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:
Image

Document: chart_break.odg

Re: Chart with very different data series

PostPosted: Sat Jan 26, 2008 11:32 am
by 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.