Results for "average prices chart"

Hello,

Can you provide an example of your data ? We don't need the real datas, but to understand how they are structurated, and what do you want exactly at the end (chart type and content, etc). An example file would be appreciated.

Every month, I download price data from the system and calculate the average price for that month. I then create a chart to visualize the inflation trend for that month. Can you provide a excel VBA code to automate this process?

- Import data - calculate average - build chart

Next month , import data add it to the same last month.. calculate the average . Build chart

Jean-Eric

Hello Good day. You are a wonderful person.

Here I am, seems embarrassed sometimes to post questions or statements, most often and someone still answered my plead.

I real appreciate it lot.

The excel you have create is wonderful. Both you and LouReeD are wonderful. I now have two excel files to help me.

Thank you for helping Jean-Eric

Hello

For fun and made with Power Query.

Calculations to check.

Regards.

Ok Thanks

But i think i make a mistake...

@ bientôt

LouReeD

Thanks for your swift reply.

I am not sure if I make the error. However, I am getting an error.

Will like to place the formula in column cell "F".

How do you want me to proceed?

Thanks.

Hello !

Sorry my English is not good !

But try this equation :

=SI(MOD(LIGNE()-1;12)=0;MOYENNE.SI.ENS($C$2:$C$5000;$B$2:$B$5000;">"&MOIS.DECALER(B6;-12);$B$2:$B$5000;"<="&B6);"")

Perapse she isgood !

Good Bye

LouReeD

Excel Pros.

I am not sure if you can help me. I just don't know.

My problem here is this:

How can I convert the 12 month rolling average: See below.

=IF(ROW(A13)<13,"",AVERAGEIFS($C$2:$C$5000,$B$2:$B$5000,">"&EDATE(B13,-12),$B$2:$B$5000,"<="&B13))

To a 12 month percentage rolling average:

If you all are willing. Here is the example below:

Hello and welcome,

try this, select the data and execute this macro.

Sub createcolumnchartwithselection()

    Set ch = ActiveSheet.Shapes.AddChart2(366, xlColumnClustered)
    ActiveSheet.ChartObjects(ch.Name).Activate
    ActiveChart.ChartArea.Select
    ActiveChart.ChartStyle = 201
End Sub

Hi there, i am new to vb excel and i need help.

What would be the macro for making excel create time series chart if two columns are selected where the left column is dates and right column is data