ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart with specified x and y (https://www.excelbanter.com/charts-charting-excel/124592-chart-specified-x-y.html)

bim_bom

Chart with specified x and y
 
Hello,
I have a table x where there isn't arithmetic progress. First numbers a
100
150
200
....
950
1000 (and then)
1100
1200
1300
....
3000

and table y:
74
3478
346
4
.....


I want to make a chart with points in exact locations:
(100,74)
(150,3478)
(200,346)

When there is an arithmetic progress in table x, there is no problem (I just
set etiquettes to cells with table x), but with the table x like above, it
doesn't work. How can I do it?

Thank you



bim_bom

Chart with specified x and y
 
OK, I found out - I have to use a XY chart, not linear :)




All times are GMT +1. The time now is 09:48 PM.

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