| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel to track product delivery | Excel Discussion (Misc queries) | |||
| How do I track DDE link usage? | Excel Discussion (Misc queries) | |||
| Need to set up a chart for BTU usage on Natural gas and Electric | Excel Worksheet Functions | |||
| Line Chart Usage | Charts and Charting in Excel | |||
| Shared resource usage chart | Charts and Charting in Excel | |||
Linear Mode
