help in plotting 2 types of data in one chart

**ida_adore** · 07-17-2012, 09:44 PM

hi there..

i have problem creating a chart using the file that i had attached.
As you can refer to the file the data contains 2 different datas which have several data in one month .I am trying to do comparision with those 2 datas.
Additionally,I need to connect the dots between the data too.
It seems easy but I had tried several times using different set of chart to create and the result is hopeless.
How can I plot those data and create a line between them too?

I would appreciate if anyone could help me resolve the problem.
Thanks in advance.

**dilipandey** · 07-18-2012, 03:59 AM

HI Ida_adore,

Welcome to the forum.

See the attached graph if this helps. thanks.

Book1(17).xls

Regards,
DILIPandey

<click on below 'star' if this helps>

**Andy Pope** · 07-18-2012, 04:07 AM

If you plot as line you can use the setting, whilst the chart is selected, Tools > Options > Chart > Interpolate. to connect between data points.

Any reason why you do not sum the values within the same period?