+ Reply to Thread
Results 1 to 3 of 3

identifying current month

  1. #1
    Sue
    Guest

    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. #2
    Barb Reinhardt
    Guest

    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. #3
    Jon Peltier
    Guest

    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.

    http://peltiertech.com/Excel/Charts/AddLine.html

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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