chart to track product usage
 

Is there a way to produce a chart that displays different products (Y axis)
against the dates they were used (x-axis)? An example would be:

Product A used from 4-20-10 to 4-30-10
Product B used from 4-15-10 to 4-20-10
Product C used from 4-18-10 to 5-3-10

I want a chart with three parallel lines that only display segments that
correspond with the dates used.

chart to track product usage
 

EXCEL 2007

Hi Jody, I have just put up a chart for you at:-

http://www.pierrefondes.com/

Item number 101.

The only thing that you might be baffled by is the Chart Worksheet cells B2
/ B3 / B4. These are your dates but in number format: so 40,288 is your
20-Apr-2010; 40,283 is your 15-Apr-2010 and so on.

Apart from this it's pretty straightforward and I think it matches your
needs.

If you agree please hit Yes.

Thanks.

"JodySmithPharmD" wrote:

Is there a way to produce a chart that displays different products (Y axis)
against the dates they were used (x-axis)? An example would be:

Product A used from 4-20-10 to 4-30-10
Product B used from 4-15-10 to 4-20-10
Product C used from 4-18-10 to 5-3-10

I want a chart with three parallel lines that only display segments that
correspond with the dates used.

chart to track product usage
 

That's it exactly! You're wonderful!

Thank you,

Jody

"trip_to_tokyo" wrote:

EXCEL 2007

Hi Jody, I have just put up a chart for you at:-

http://www.pierrefondes.com/

Item number 101.

The only thing that you might be baffled by is the Chart Worksheet cells B2
/ B3 / B4. These are your dates but in number format: so 40,288 is your
20-Apr-2010; 40,283 is your 15-Apr-2010 and so on.

Apart from this it's pretty straightforward and I think it matches your
needs.

If you agree please hit Yes.

Thanks.

"JodySmithPharmD" wrote:

Is there a way to produce a chart that displays different products (Y axis)
against the dates they were used (x-axis)? An example would be:

Product A used from 4-20-10 to 4-30-10
Product B used from 4-15-10 to 4-20-10
Product C used from 4-18-10 to 5-3-10

I want a chart with three parallel lines that only display segments that
correspond with the dates used.