Unequal x values

[vin1602]

Hi I have data on samples collected at different time periods;eg

Time Collected, Period of Collection (hrs), Value
1, 0-1, 14
4, 1-4, 4
14,5-14,2
16, 15-16, 4
18, 17-18, 6
30, 19 - 30, 3

Is it possible to plot these on a bar graph, such that the bars will have unequal widths, corresponding to the time period of collection. Hope this makes sense.
Thank you

 

[pgc01]

Hi

You just have to change your table layout and repeat the values the number of times corresponding to the time period of collection.

For ex., for the data you posted, try for the first values

1, 14
2, 4
3, 4
4, 4
5, 2
6, 2
7, 2
8, 2
9, 2
10, 2
11, 2
12, 2
13, 2
14, 2
15, 4
16, 4

use these values to make a column chart and set the gap between the columns to zero.

 

[vin1602]

any many thanks pg01!!

 

[pgc01]

You're welcome. Thanks for the feedback.