Line charts

TomESol

New Member
Joined
May 3, 2012
Messages
2
This is the problem: I'm trying to make a force x velocity line graph with pre and post variables in this chart. The problem is that the post variables for velocity doesn't fit in, in the x axis with the pre variables. How do I do that??

PS: Sorry for bad english :)
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Hi Tom
Welcome to the board

First, force and velocity are quantities and so you do not need a line chart, you need a scatter chart.

Second, I'm sorry but it not clear the pre and post variables. Can you post some sample data and elaborate on the problem?
 
Upvote 0
I don't know if this link works: https://plus.google.com/u/0/photos/...lbums/5738337281527562561/5738337279257507250

To the right it's the line chart and to the right it's the scatter chart with smooth lines. The scattter chart: red represents pre force, green post force, x axis pre velocity and blue post velocity. How do I fit the post velocity in the x axis? Is it even possible? Because, if you see post force, 1462, with a velocity, 0,96. The end of the green line should then be higher. But it seems to take the 1061 post force instead.

Hope the problem is a bit clearer now, hope you can help :)
https://plus.google.com/u/0/photos/...lbums/5738337281527562561/5738337279257507250
 
Upvote 0

Forum statistics

Threads
1,214,614
Messages
6,120,533
Members
448,969
Latest member
mirek8991

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top