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

Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

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

Postby arunstar » Thu Feb 11, 2010 8:30 am

This is the final chart that has Column-Line graph with a secondary Y-Axis.
graph.JPG
The final Column-Line Graph, with two Y-axis.


Here is the sample data.
data.jpg
CSV data file.


How to make this?

Step 1. Choose Columns
1. Choose avg and cumulative coulmns.JPG
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

Postby arunstar » Thu Feb 11, 2010 8:44 am

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

Postby arunstar » Thu Feb 11, 2010 8:46 am

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

Postby arunstar » Thu Feb 11, 2010 8:49 am

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

Postby arunstar » Thu Feb 11, 2010 8:52 am

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?

Postby arunstar » Fri Feb 12, 2010 8:51 am

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
arunstar
 
Posts: 6
Joined: Thu Feb 11, 2010 7:38 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 0 guests