Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i select the points on the x axis
i have two sets of data
on the left column represents time, hours. i want the numbers on the right to be appear on the graph at the appropriate hour. so 9.0 should appear at the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the chart, the hours being spread by ones on the x axis. 43 9.0 52 4.8 81 5.9 242 1.5 146 3.8 159 2.9 194 3.3 217 2.6 242 3.5 251 2.9 312 3.0 355 2.0 454 1.9 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i select the points on the x axis
Create an XY scatter chart, with the first column being your X-axis.
-- Best Regards, Luke M "kylefoley2000" wrote in message ... i have two sets of data on the left column represents time, hours. i want the numbers on the right to be appear on the graph at the appropriate hour. so 9.0 should appear at the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the chart, the hours being spread by ones on the x axis. 43 9.0 52 4.8 81 5.9 242 1.5 146 3.8 159 2.9 194 3.3 217 2.6 242 3.5 251 2.9 312 3.0 355 2.0 454 1.9 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i select the points on the x axis
Hi Kyle.
I have just put up an EXCEL 2007 file for you at:- http://www.pierrefondes.com/ - item number 79 towards the top of my home page. I think that this gives you what you want. If you agree please hit Yes. Thanks. "kylefoley2000" wrote: i have two sets of data on the left column represents time, hours. i want the numbers on the right to be appear on the graph at the appropriate hour. so 9.0 should appear at the 43rd hour on the chart, 4.8 should appear at the 52nd hour on the chart, the hours being spread by ones on the x axis. 43 9.0 52 4.8 81 5.9 242 1.5 146 3.8 159 2.9 194 3.3 217 2.6 242 3.5 251 2.9 312 3.0 355 2.0 454 1.9 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different Starting Points on X-Axis | Charts and Charting in Excel | |||
Axis points | Charts and Charting in Excel | |||
Data points going from axis to axis | Charts and Charting in Excel | |||
How to select an axis that is covered by data points? | Charts and Charting in Excel | |||
How do I select multiple data points on my chart? | Charts and Charting in Excel |