Results 1 to 2 of 2
Thread: Variable time frames on x-axis
2011-11-23, 14:27 #1
- Join Date
- Jan 2001
- La Jolla, CA
- Thanked 63 Times in 59 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).
2011-11-24, 07:00 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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.