x-Axis values

  • Thread starter Thread starter Jakub Kolasinski
  • Start date Start date
J

Jakub Kolasinski

I have to create a chart that has X-values 1 - 20000. They have to become
more and more dense as the value grows. Distance between values has to
decrease (as the values on x-axis grow).

Ho to do it? Please help me...
 
I will assume your x-values are in column A, y-values in B
In C1 enter =IF(MOD(ROW(),100)=0,B1,NA() )
Then chart data in A against that in C - it will chart every 100th data
point

For more info see one of my book: "Microsoft Excel w nauce i technice" or
"Microsoft Excel; w biznesie i zarzqdzaniu" published by Wydawnnictwo RM
 
Back
Top