Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
CRS is getting me
Excel V2007
This is the simplest chart. I cannot believe I spent 45 minutes on this and still don't have it the way I want. Plotting an xy line graph a few months of selected utility bills. Three columns of data, date, amount and Utility Y axis is amount, X axis is date and data point label is Utility name. Heres what the data looks like. Date Amount Utility 24-Mar-09 $98.04 Gas 30-Mar-09 $80.00 Electric 10-Apr-09 $167.31 Electric 15-Apr-09 $19.04 Gas 30-Apr-09 $45.76 DSL/Phone 11-May-09 $10.00 Water 12-May-09 $93.22 Electric 14-May-09 $41.37 Trash 15-May-09 $17.21 Gas 28-May-09 $45.91 DSL/Phone 10-Jun-09 $85.44 Electric 15-Jun-09 $19.01 Gas 26-Jun-09 $43.76 DSL/Phone 30-Jun-09 $76.85 Water 14-Jul-09 $17.19 Gas 15-Jul-09 $99.18 Electric 16-Jul-09 $41.94 Trash TIA, GWB |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
CRS is getting me
Hi,
Try this free utility to link data labels to cell text. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy Microsoft wrote: Excel V2007 This is the simplest chart. I cannot believe I spent 45 minutes on this and still don't have it the way I want. Plotting an xy line graph a few months of selected utility bills. Three columns of data, date, amount and Utility Y axis is amount, X axis is date and data point label is Utility name. Heres what the data looks like. Date Amount Utility 24-Mar-09 $98.04 Gas 30-Mar-09 $80.00 Electric 10-Apr-09 $167.31 Electric 15-Apr-09 $19.04 Gas 30-Apr-09 $45.76 DSL/Phone 11-May-09 $10.00 Water 12-May-09 $93.22 Electric 14-May-09 $41.37 Trash 15-May-09 $17.21 Gas 28-May-09 $45.91 DSL/Phone 10-Jun-09 $85.44 Electric 15-Jun-09 $19.01 Gas 26-Jun-09 $43.76 DSL/Phone 30-Jun-09 $76.85 Water 14-Jul-09 $17.19 Gas 15-Jul-09 $99.18 Electric 16-Jul-09 $41.94 Trash TIA, GWB -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|