r1998
Board Regular
- Joined
- Sep 9, 2018
- Messages
- 106
Dear Friends and Respected Seniors,
I have a chart containing a Line Chart Series and an XY Scatter Chart Series. Data for Line Chart is from A1-B9 and data for XY Scatter Chart is from A11-B19.
Data from A1-B19 is
<tbody>
</tbody>
The chart is generated correctly.
https://paste.pics/4XOFK
but when i change data of Column A, the chart generated is incorrect.
The new data from A1-B19 is
<tbody>
</tbody>
The chart is generated incorrectly
https://paste.pics/4XOGB
What am I doing wrong ?
Can anyone please kindly point out my mistake and help me.
Awaiting your replies.
Thank you.
I have a chart containing a Line Chart Series and an XY Scatter Chart Series. Data for Line Chart is from A1-B9 and data for XY Scatter Chart is from A11-B19.
Data from A1-B19 is
Line Data | |
1 | #N/A |
2 | 84 |
3 | 55.7 |
4 | 67.5 |
5 | 43.55 |
6 | #N/A |
7 | 75.55 |
8 | 52.5 |
XY Scatter Data | |
1 | #N/A |
2 | 84 |
3 | 55.7 |
4 | 67.5 |
4 | 43.55 |
4 | #N/A |
4 | 75.55 |
4 | 52.5 |
<tbody>
</tbody>
The chart is generated correctly.
https://paste.pics/4XOFK
but when i change data of Column A, the chart generated is incorrect.
The new data from A1-B19 is
Line Data | |
10 | #N/A |
20 | 84 |
30 | 55.7 |
40 | 67.5 |
50 | 43.55 |
60 | #N/A |
70 | 75.55 |
80 | 52.5 |
XY Scatter Data | |
10 | #N/A |
20 | 84 |
30 | 55.7 |
40 | 67.5 |
40 | 43.55 |
40 | #N/A |
40 | 75.55 |
40 | 52.5 |
<tbody>
</tbody>
https://paste.pics/4XOGB
What am I doing wrong ?
Can anyone please kindly point out my mistake and help me.
Awaiting your replies.
Thank you.