chart to track product usage

J

JodySmithPharmD

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.
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make a mekko chart in Excel 2007 in three easy Steps 1
Cumulative chart 1
How to remove weekends from the chart 2
Make Y-axis values correspond to x- axis value 1
Dates posted within a standard column chart 1
Co-ordinates plotting on Graph //sk 1
Line chart from data in 2 sheets 1
How do I create this chart? 1

Top