Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Variable time frames on x-axis

    I haven't had time to seriously explore this on my own, but thought I'd toss it out to see if anyone has already faced this issue and has a solution, suggestion, etc.

    Is it possible to have a set of data in Excel and graph that data in one chart where the x-axis changes in time-frame? For example, I have data that is weekly sales for 3 months, then monthly sales for 6 months, then yearly sales for 3 years.

    As I type this and think about it, I guess I could just graph the data straight-away, and change the labels on the x-axis to reflect the time frame(s).

    Any thoughts/comments?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    The ways I have done:
    You can plot as a line where each item is spaced equally

    If you want unequal spacing, but eliminate some large gaps in time, I would use and XY and create a Auxiliary X range which has the gaps in time removed and if you need labels work on some sec X-Axis to created on a line chart to display an axes.

    The details would be more custom and we would need more details on the setup and spacing desired (perhaps an example worksheet and a sample chart.

    Steve

Posting Permissions

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