chartin different numer elements in the same time range

F

frenz

In Excel I have 3 rows of numbers:

1: 12, 44, 16, 12, 19
2: 1, 4, 87
3: 3, 1.

Imagine they are financial transactions:
They have happened in the same time range, from 8PM to 12PM, but
There's no exact time.

How can I have one chart displaying

row 1's data: 12 at 8PM, 44 at 9PM, 16 at 10PM, 12 at 11PM, 19 a
12PM;

row 2's data: 1 at 8PM, 4 at 10PM, 87 at 12PM

row 3's data: 3 at 8PM and 1 at 12P?

So that the transactions are considered to have happened iregularly i
the same time span?

thank you.
it's a prblem is making me crazyyyy :eek
 
D

Debra Dalgleish

If the numbers are in the same column in the source data, and plotted on
the same axis in the chart, they'll be at the same time marker. So, the
second value for each series would be at 9 PM, and the third at 10 PM.

You could plot the shorter series on a secondary X axis, and change its
scale, but that would only partially solve the problem, and would shift
the first value off the 8 PM marker.

The best solution would be to move the numbers in the source data, so
they're evenly distributed in the time frame. Then, create the chart
from the revised data.
 
Top