Making a graph with 2 Axis of Y with Calc

[ekokoua]

I have a problem with Calc.

I would like to make a Graph with 2 Axis of Y.
for example

X 1 2 3 8 10
Y1 2 4 5 1 0

X 1 2 3 8 10
Y2 100 3000 5000 8000 30000

Y1 will be in the first axe of Y and Y2 in the second axe.
But i dont know who to it in Calc or by code.


Can you help me?
_________________
I love work.

[RickRandom]

I'm new to OpenOffice, but in Excel you would select the line you want to appear on the second axis, right click or go to the Format menu or double-click the line, select the tab for axis, and select Secondary, then OK.

I would expect OOo to be nearly the same but it crashed on me when I tried it!. (v1.1.5)

I am assuming that you can already get a graph with the data on it, just that one series appears to be stuck down on the x-axis.

If this doesn't help, ask again.

[jrkrideau]

[RickRandom]

I think jrkrideau and I are slightly at cross-purposes.

My method is:

1. Highlight the cells to be graphed, including the cells for the labels, the X values, and the two rows of Y values.

2. Using the menus, Insert->Chart, and follow the steps, e.g. X-Y graph, etc.

3. When the graph is created, one of the lines will be almost flat down on the x-axis, because it has the small Y values.

4. Right-Click on the graph and select Edit.

5. Double-Click on the line that fits the chart size, and you will get a window titled "Data Series". Select the Options tab, and select 2nd Y axis.

If I knew how to get pictures in this forum, I'd put in the screen shots.

If this succeeds, let me know - I'm only starting with OpenOffice.

[jrkrideau]

[RickRandom]

I managed to get it to work in 2.0 (downloaded today!)

If I could grasp how to put a screen shot, I'd show you the wndow and the result.

Any help on that? I don't know how I put a file from my hard drive as a link using the Img button.

[jrkrideau]

[RickRandom]

[img]http://www.mytempdir.com/413842[/img]

[img]http://www.mytempdir.com/413844[/img]

http://www.mytempdir.com/413844

http://www.mytempdir.com/413842

I don't seem to have got the hang of the mages yet!!

[bobharvey]

[jrkrideau]

[RickRandom]

I can't seem to get a Secondary axis title.

If I put one in using Excel, then open the same file in Calc, the secondary title is not there. The secondary axis is there OK , just the Primary title on the left axis.

I guess the feature doesn't exist in Calc, but at least the Secondary axis is useable, and scalable, so the most important things are there.

My feeling is that Charting is something of a weakness in Calc, not critical, but Excel is slicker. Maybe it's that I'm high up on the Excel learning curve, low down on the Calc learning curve. I have now got Calc's Help working, so perhaps that will clear up a few things...

I'll keep on posting, as it helps me learn by helping solve other people's problems, and I get a kick out of it.

[jrkrideau]