how to create a line-chart with 2 sets of data who has different x

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank_C - 30 Aug 2008 13:27 GMT

hi, i don't know how to create a line-chart with 2 sets of data, they have
different size. Say set_1 has x-axe from 0 - 12 with 150 intervals. Set_2 has
x-axe from 0-14 with 130 intervals. How to put them into a single line chart?

Reply to this Message

Jon Peltier - 30 Aug 2008 15:55 GMT

Make an XY chart instead. You can connect the markers with lines in both
types of charts.

http://peltiertech.com/WordPress/2008/07/10/line-charts-vs-xy-charts/

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

> hi, i don't know how to create a line-chart with 2 sets of data, they have
> different size. Say set_1 has x-axe from 0 - 12 with 150 intervals. Set_2
> has
> x-axe from 0-14 with 130 intervals. How to put them into a single line
> chart?

Reply to this Message