lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I wanted to insert a chart for the data below. The dates are duplicated in x-axis, for example i have 14/10/2018 twice? why is that?
Thank you. excel 2013
[TABLE="width: 203"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]day[/TD]
[TD]temp high[/TD]
[TD]temp low[/TD]
[/TR]
[TR]
[TD="align: right"]14/10/2018[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]15/10/2018[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]16/10/2018[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]17/10/2018[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]18/10/2018[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]9[/TD]
[/TR]
</tbody>[/TABLE]
I wanted to insert a chart for the data below. The dates are duplicated in x-axis, for example i have 14/10/2018 twice? why is that?
Thank you. excel 2013
[TABLE="width: 203"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]day[/TD]
[TD]temp high[/TD]
[TD]temp low[/TD]
[/TR]
[TR]
[TD="align: right"]14/10/2018[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]15/10/2018[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]16/10/2018[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]17/10/2018[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]18/10/2018[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]9[/TD]
[/TR]
</tbody>[/TABLE]