Line Chart

[Megatronv]

Hi

I'm trying to plot a daily moving average line chart, I've managed to calculate the values and plot the chart, however, the problem I have is that I want the graph to have descending values on the x-axis, so that last daily value corresponds to the last value on the y-axis instead of the first one;

example:

day 1 moving average value (MAV): 2
day 2 MAV: 3
day 3mav: 3.5

I want the graph to plot the value of day 1 on the x-axis as the last value instead of value for 3

Thanks

[Andy Pope]

Have you tried the Axis option, plot values in reverse order?

[Megatronv]

I thought about it but not sure how to reverse the x-axis?

[Andy Pope]

Double click the X axis and then on the dialog select Reverse order.

If still stuck post example file

[Megatronv]

Apologies but I can't get it to work Excel.xlsx

[Andy Pope]

screen shot of format dialog included

[Megatronv]

Perfect

tks a lot