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
"Sue" wrote in message
...
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?
|