identifying current month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with finance data which I put into line graphs. Is there anyway
to identify the current month without having to manually put in and move a
line in 30plus graphs?
 
Let me make sure I understand what you want. Before I answer any further,
do you want all months on the graph, but you want the current month to look
different on the graph? If that's the case, I'd create two columns of data
for the chart.

Column A - Date Information
Column B - Financial Data
Column C - Current month data
Column D - Non-current Month Data

Enter in C3
=IF(MONTH(A3)=MONTH(TODAY()),B3,NA())
Enter in D3
=IF(MONTH(A3)<>MONTH(TODAY()),B3,NA())

This should get you started.

Have a great day!
Barb Reinhardt
 
Back
Top