Hi All,
Apologies if this has been asked before but I have searched and only found similar requests, nothing solving my exact issue.
I have some weekly KPI data which gets collated each month into charts. The data is entered each week and totaled using sum formulas onto a sheet. I have a chart on another sheet that I would like to transpose this data onto (the data currently has the months as column headers but the chart needs them to be as rows). My issue is that I only want to show last month and earlier and hide the data entered so far for this month.
Example:
Original data:
<tbody>
</tbody>
How I want to see the chart data:
<tbody>
</tbody>
What I would like to do is have a transpose formula to enter the data onto the chart but only if the month is lower than today's month.
I hope this makes sense.
Thanks in advance,
Gav
Apologies if this has been asked before but I have searched and only found similar requests, nothing solving my exact issue.
I have some weekly KPI data which gets collated each month into charts. The data is entered each week and totaled using sum formulas onto a sheet. I have a chart on another sheet that I would like to transpose this data onto (the data currently has the months as column headers but the chart needs them to be as rows). My issue is that I only want to show last month and earlier and hide the data entered so far for this month.
Example:
Original data:
Jan | Feb | Mar | Apr |
100 | 150 | 125 | 25 |
<tbody>
</tbody>
How I want to see the chart data:
Jan | 100 |
Feb | 150 |
Mar | 125 |
Apr |
<tbody>
</tbody>
What I would like to do is have a transpose formula to enter the data onto the chart but only if the month is lower than today's month.
I hope this makes sense.
Thanks in advance,
Gav