Linear x axis distribution in Pivot Chart

**Cheenn** · 02-27-2020, 12:02 PM

Hello !

I'm trying since this morning to find a solution in order to have linear distribution on my x axis.
The first value is at 40, then 122, 204, 280 ... 1554, 1625, 1746, 1922.
As you can see, it's not linear, my goal is to put a fix step at 50 : 0, 50, 100, 150, 200...

I saw solutions about creatin XY chart but it's not possible with pivot charts (and I need to stay with pivot chart).
Thanks for the help.

**MrShorty** · 02-27-2020, 12:09 PM

Would an XY scatter chart solve your problem? If so, you are correct that a pivot chart cannot be an XY scatter chart. The solution is to create a regular XY scatter chart without letting it become a pivot chart: https://peltiertech.com/regular-char...-pivot-tables/

**Cheenn** · 02-27-2020, 12:12 PM

Thank you for your answer MrShorty, indeed I found this solutions on google and it works.
The problem is that I need to have automatic Excel document (my datas are from some Python scripts) and I really don't want to spend too much time trying to solve it using Python.
That's why I would be very happy to find a solution with pivot chart ...

**MrShorty** · 02-27-2020, 12:21 PM

What is not automatic about your current procedure?

**Cheenn** · 02-27-2020, 12:24 PM

If I create XY chart, it won't be a pivot chart and it means it won't be able to actualize the datas when I add datas in this Excel file.
I want my scripts to add data, I open the Excel file, i press "actualise data" button and my graphics are ready and updated.
(Maybe i'm wrong) but maybe it's not possible to do that with Excel ? (having a linear x axis with pivot chart).

**MrShorty** · 02-27-2020, 01:29 PM

I'm not sure why your scatter chart does not update when you refresh/actualise the data. You must be doing something different from what I would do, but I don't know what it is.

Here's a file I created really quick. It uses random numbers in place of whatever your python script is showing. Because these numbers will change with each calculate event, you need only press "actualise data" to get the pivot table to update with the new values, and you should see the chart follow the pivot table. Perhaps this will help you see the detail you are doing, or allow you to describe the detail that you need to be different.