This is the final chart that has Column-Line graph with a secondary Y-Axis.
Step 1. Choose Columns
Here is the sample data.
How to make this?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.
No question in this section 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?
OpenOffice 3 on Windows
How to make Column and Line Chart with two y axis? - part 2
Step 2. Add time as Category
Step 3. Add Chart Elements
Step 4. Streatch the chart
OpenOffice 3 on Windows
How to make Column and Line Chart with two y axis? - part 3
Step 5. Click on the yellow bar and invoke rt menu - select Chart Type
Step 6. Select Column and Line, Number of lines as 1
Step 7. Number of lines as 2
OpenOffice 3 on Windows
How to make Column and Line Chart with two y axis? - part 4
Step 8. Click on the green line, choose Object Properties
Step 9. Data Series window, choose Options, Secondary Axis
Step 10. Sec Y-axis appears - both sides
OpenOffice 3 on Windows
How to make Column and Line Chart with two y axis? - final 5
Step 11. Choose yellow line and do same steps
Step 12. The Chart is complete
OpenOffice 3 on Windows
Re: How to make Column and Line Chart with two Y axis?
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
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