Solved

How to use OpenOffice sCalc to plot 2 columns of different data?

Posted on 2011-03-05
6
881 Views
Last Modified: 2012-06-27
I have three columns of data. The first column are dates, the second has data that varies from 0.001 to 100, and the third column has data that varies from 6,000 to 14,000.

My question is how do I plot the third column in the same graph? I need to see how the data varies for the third column in relation to the 2nd column.

 I would like to see the dates as the x-axis - along the bottom of the graph, the second column along  the left side of the graph, and the third column alongside the right side of the graph. If this is not possible then all I need to see the dates (x-axis), and the 2nd column along the right side of the chart.

Here is what I am getting now, the 3rd column is the blue line sloping up from the bottom left.


Thanks. image of what I am getting
0
Comment
Question by:John_2357
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 350 total points
ID: 35043257
Please upload your file.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 35043275
John_2357,

As this is an Excel zone my answer uses Excel - see attached file.

Patrick
John-2357-01.xls
0
 
LVL 3

Assisted Solution

by:JAMcDo
JAMcDo earned 100 total points
ID: 35043528
Attached is my attempt that appears to work.

 Test-DualPlot.ods

The steps I used were to:
- select the date range (3 columns - Col. A for X-Values and Cols B & C for Y-Values)
- Choose Chart Type as 'Stock' and choose a style with a left and right y-axes
- For Data Range, select 'Data Series in Columns', and check both 'First Row as Label' and 'First Column as Label'
- For Data Series, select 'Unnamed Series' and enter the cell reference for the column name into 'Range for Name'
- For Chart Elements, enter labels/titles as desired, make choices as to appearance and legend location
- As the chart type will be bar, return to 'Chart Type' and select 'Line' and select style of your choice
- Click Finish

I am using OpenOffice 3

Hope this helps,

J.
 
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:John_2357
ID: 35043564
In your reply, What I need to see is the data of Column B and Column C  take up the full vertical space of the chart. In other words they overlap, where the line for 'B' varies from 10 to 998 and it runs from the bottom to the top of the chart, likewise for 'C'.

I have attached the spreadsheet, thank you for your reply.

I opened your file and from that was able to modify my graph so that I get what you had, but I would really like to have both lines plot from the top to the bottom in the chart. What I did is in the xls file.

I guess I made a mistake in the parameters for this question, I am not using Excel but sCalc (spreadsheet from Open Office). Should I re-post?  I think that what you recommend in Excel will also work in sCalc.

Thanks
john

 after using your suggestionsample.ods
sample.xls
0
 
LVL 37

Assisted Solution

by:TommySzalapski
TommySzalapski earned 50 total points
ID: 35044882
I guess I made a mistake in the parameters for this question,
I disagree. You made it clear in the title that you were using sCalc. Since Excel and sCalc are so similar and Excel is a much higher traffic zone, it makes sense to tap the brains in that zone. You just need to accept the fact that you may have to translate a solution back into OpenOffice, but that will often be an easy task.
Should I re-post?
Please never do this. You can hit 'request attention' and ask the moderators to move the question to a different zone or email zone experts to ask for additional help, but please don't post duplicate questions. (Although, in this case I don't think you need to move anything).
0
 
LVL 37

Expert Comment

by:TommySzalapski
ID: 35044893
I see you already have two y axes. If you right click on the axis and choose to format it, you should see an option to set manually the minimum and maximum. Just set these to the min and max of the data and the graphs will hit the top and bottom.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question