identifying current month

1. identifying current month

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?

2. Re: identifying current month

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" <Sue@discussions.microsoft.com> wrote in message
news:CB11F9B0-1081-4076-9637-645ED3F0BAB2@microsoft.com...
>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?

3. Re: identifying current month

Sue -

Another way, if you wanted an actual line, is to follow one of these
techniques, using a variation on Barb's formulas to determine where the
line should be positioned.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Sue wrote:

> 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?

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1