+ Reply to Thread
Results 1 to 4 of 4

Last 12 months chart

  1. #1
    mccall213
    Guest

    Last 12 months chart

    I have a whole lot of charts that feed off of data that is broken down into
    regions in the rows and months going across the top of columns. every thing
    i found so far on dynamic charts works with date ranges going down a column,
    not across. How do i get it to work the way my data is set up.

  2. #2
    Kelly O'Day
    Guest

    Re: Last 12 months chart

    Mccal213:

    Have you considered transposing your source data? Dates in rows is the
    convention because you have thousands of possible rows and only 256 columns.

    You can select your data, copy and transpose with paste special. try it on a
    copy sheet to see if you can live with the more standard approach.

    If not, then you will need to adjust the offset formulas that are used in
    dynamic chart range names.

    ...Kelly




    "mccall213" <[email protected]> wrote in message
    news:[email protected]...
    >I have a whole lot of charts that feed off of data that is broken down into
    > regions in the rows and months going across the top of columns. every
    > thing
    > i found so far on dynamic charts works with date ranges going down a
    > column,
    > not across. How do i get it to work the way my data is set up.




  3. #3
    mccall213
    Guest

    Re: Last 12 months chart

    thanks

    "Kelly O'Day" wrote:

    > Mccal213:
    >
    > Have you considered transposing your source data? Dates in rows is the
    > convention because you have thousands of possible rows and only 256 columns.
    >
    > You can select your data, copy and transpose with paste special. try it on a
    > copy sheet to see if you can live with the more standard approach.
    >
    > If not, then you will need to adjust the offset formulas that are used in
    > dynamic chart range names.
    >
    > ...Kelly
    >
    >
    >
    >
    > "mccall213" <[email protected]> wrote in message
    > news:[email protected]...
    > >I have a whole lot of charts that feed off of data that is broken down into
    > > regions in the rows and months going across the top of columns. every
    > > thing
    > > i found so far on dynamic charts works with date ranges going down a
    > > column,
    > > not across. How do i get it to work the way my data is set up.

    >
    >
    >


  4. #4
    Tushar Mehta
    Guest

    Re: Last 12 months chart

    In article <[email protected]>, mccall213
    @discussions.microsoft.com says...
    > I have a whole lot of charts that feed off of data that is broken down into
    > regions in the rows and months going across the top of columns. every thing
    > i found so far on dynamic charts works with date ranges going down a column,
    > not across. How do i get it to work the way my data is set up.
    >

    Kelly's suggestion is on the mark. But, if you must keep columns, just
    adjust the OFFSET formula (assuming that's what you are using) to refer to
    starting column and number of columns rather than starting row and number of
    rows. For how, check XL help for the OFFSET function.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1