| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create a macro to create excel line graph with coloured pointers anddata lables
Hi guys.
Need to leverage some expertise please. For example, if we have the table: Date Project Delivery Date Status Comments 01/02 x 01/05/2009 Green original date 07/02 x 08/05/2009 Amber delay supply 14/02 x 20/05/2009 Red out of money 21/02 x 30/05/2009 Green on track 28/02 x 28/02/2009 Blue delivered-wow So id like the macro to draw the line for project x based on the 'delivery date'. The points should be coloured according to the 'status' column and when you hover the mouse over the point the data lable will show up taking info from the 'comments' column. Would it be possible to create a macro that will be able to generate this graph automatically. I have a few projects id like to do the same thing for. Any help would be amazing!!! Thanks in advance guys. EggHeadCafe - Software Developer Portal of Choice WPF DataGrid Custom Paging and Sorting http://www.eggheadcafe.com/tutorials...tom-pagin.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create line graph with 3 variables? | Excel Discussion (Misc queries) | |||
| Create simple line graph in Excel!!!!! | Charts and Charting in Excel | |||
| how do I create a line graph from a common origin? | Charts and Charting in Excel | |||
| How do you create a cumulative line graph? | Excel Discussion (Misc queries) | |||
| How do I create a line graph with x- y axis? | Charts and Charting in Excel | |||
Threaded Mode
