[Solved] Chart with very different data series

Discuss the spreadsheet application

[Solved] Chart with very different data series

Postby metalchrist » Fri Jan 25, 2008 7:11 pm

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. 
Last edited by Hagar Delest on Tue Jun 10, 2008 2:15 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
metalchrist
 
Posts: 3
Joined: Fri Jan 25, 2008 7:08 pm

Re: Chart with very different data series

Postby acknak » Fri Jan 25, 2008 8:08 pm

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.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Chart with very different data series

Postby metalchrist » Fri Jan 25, 2008 8:35 pm

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?
metalchrist
 
Posts: 3
Joined: Fri Jan 25, 2008 7:08 pm

Re: Chart with very different data series

Postby acknak » Fri Jan 25, 2008 10:10 pm

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
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Chart with very different data series

Postby metalchrist » Sat Jan 26, 2008 11:32 am

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.
metalchrist
 
Posts: 3
Joined: Fri Jan 25, 2008 7:08 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 22 guests