Re: column plot with 2 y-axes



You can add a dummy series (set the values to 0 for these series or use
empty cells) to each plot, one as first series and the other as second
series as in attached sample.

Regrds,
Jean

Le dimanche 03 juillet 2011 à 21:35 +0200, ratflat gmx de a écrit :
Hi,

I've got a problem in using gnumeric for a column plot with 2 data sets to be displayed on 2 y-axes. 
Everything works fine concerning the selection of data and the addition of the second y-axis, but the bars 
in the chart are overlapping, because i cannot change the position of each data set on the x-axis and by 
default they are located on exactly the same spots in the chart. I need a second y-axis, because the data 
to be displayed on the first and second axis are using different intervals, so that the bars for the first 
axis wouldn't be visible on the second axis.

To illustrate my problem, I have created this data set:

name / value 1 / value 2
a    /    1    / 4000
b    /    4    / 2038
c    /    3    /23081
d    /    4    / 2398
e    /    0    /  345

I would like to have a chart like the plot sub-type on the left in this chart: 
http://projects.gnome.org/gnumeric/doc/figures/graph-example-column.png , just with a second y-axis.

Is it possible to create such charts in gnumeric?

I am grateful for every hint!
Thanks in advance,
Jakob

Attachment: Book1.gnumeric
Description: application/gnumeric



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]