ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I make individual x values? (https://www.excelbanter.com/charts-charting-excel/102588-how-can-i-make-individual-x-values.html)

gpktm

How can I make individual x values?
 

How can I make a graph which each curve has individual x-axis values?

Like the example below

http://www.excelforum.com/attachment...d=115447762 6
ctgrcrvs.gif


+-------------------------------------------------------------------+
|Filename: ctgrcrvs.gif |
|Download: http://www.excelforum.com/attachment.php?postid=5136 |
+-------------------------------------------------------------------+

--
gpktm
------------------------------------------------------------------------
gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=567278


HEK

How can I make individual x values?
 
Use XY scatter charts, group the data points belonging to the same data
series in one series, and connect the data points of each series with lines.
HTH,
Henk

"gpktm" wrote:


How can I make a graph which each curve has individual x-axis values?

Like the example below

http://www.excelforum.com/attachment...d=115447762 6
ctgrcrvs.gif


+-------------------------------------------------------------------+
|Filename: ctgrcrvs.gif |
|Download: http://www.excelforum.com/attachment.php?postid=5136 |
+-------------------------------------------------------------------+

--
gpktm
------------------------------------------------------------------------
gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=567278



gpktm

How can I make individual x values?
 

HEK Wrote:
Use XY scatter charts, group the data points belonging to the same data
series in one series, and connect the data points of each series with
lines.
HTH,
Henk



I'm kind a beginer in Excel I know only some basic functions and
charting, can help me little bit more? Can you tell step by step what
to do? Or reffer me to any tutorial on the internet if it is available.


--
gpktm
------------------------------------------------------------------------
gpktm's Profile: http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=567278


Jon Peltier

How can I make individual x values?
 
Make a chart with the X & Y data for the first curve. Select and copy the X
& Y data for the second curve, select the chart, and use Paste Special from
the Edit menu to add the data as a new series. Repeat for all the additional
curves.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"gpktm" wrote in
message ...

HEK Wrote:
Use XY scatter charts, group the data points belonging to the same data
series in one series, and connect the data points of each series with
lines.
HTH,
Henk



I'm kind a beginer in Excel I know only some basic functions and
charting, can help me little bit more? Can you tell step by step what
to do? Or reffer me to any tutorial on the internet if it is available.


--
gpktm
------------------------------------------------------------------------
gpktm's Profile:
http://www.excelforum.com/member.php...o&userid=17538
View this thread: http://www.excelforum.com/showthread...hreadid=567278





All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com