How to make Column and Line Chart with two Y axis?

Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

How to make Column and Line Chart with two Y axis?

Post by arunstar »

This is the final chart that has Column-Line graph with a secondary Y-Axis.
The final Column-Line Graph, with two Y-axis.
The final Column-Line Graph, with two Y-axis.
Here is the sample data.
CSV data file.
CSV data file.
How to make this?

Step 1. Choose Columns
Choose Cols
Choose Cols
OpenOffice 3 on Windows
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

How to make Column and Line Chart with two y axis? - part 2

Post by arunstar »

Step 2. Add time as Category
2. Add time as Category.JPG
Step 3. Add Chart Elements
3. Add Chart Elements.JPG
Step 4. Streatch the chart
4. Streatch the chart.JPG
OpenOffice 3 on Windows
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

How to make Column and Line Chart with two y axis? - part 3

Post by arunstar »

Step 5. Click on the yellow bar and invoke rt menu - select Chart Type
5. Click on the yellow bar and invoke rt menu - select Chart Type.JPG
Step 6. Select Column and Line, Number of lines as 1
6. Select Column and Line, Number of lines as 1.JPG
Step 7. Number of lines as 2
7. Number of lines as 2.JPG
OpenOffice 3 on Windows
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

How to make Column and Line Chart with two y axis? - part 4

Post by arunstar »

Step 8. Click on the green line, choose Object Properties
8. Click on the green line, choose Object Properties.JPG
Step 9. Data Series window, choose Options, Secondary Axis
9. Data Series window, choose Options, Secondary Axis.JPG
Step 10. Sec Y-axis appears - both sides
10. Sec Y-axis appears - both sides.JPG
OpenOffice 3 on Windows
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

How to make Column and Line Chart with two y axis? - final 5

Post by arunstar »

Step 11. Choose yellow line and do same steps
11. Choose yellow line and do same steps.JPG
Step 12. The Chart is complete
12. The Chart is complete.JPG
OpenOffice 3 on Windows
arunstar
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am

Re: How to make Column and Line Chart with two Y axis?

Post by arunstar »

One Note, In the data set that has Time,Avg, Avg, Cumulative and Cumulative columns.
The order is important,
Last two columns will give you Line graph.
First two columns will give you histogram(column) graph.

If you rearrange the columns then it become cumbersome to make the Column and Line chart in same graph.

- Arun
OpenOffice 3 on Windows
Post Reply