If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|