Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates and Recomended Graphing Programs to work with excel?
Is there a way to have excel not graph a space in between dates that are not
right in a row... for example. if I have 12-1, 12-2, 12-3, and then jump to 12-6.... how can I avoid that space in my graph. also... I find excel graph's to be difficult to work with... are there any recomended charting programs that work with excel that have more functionality and just work better? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates and Recomended Graphing Programs to work with excel?
Hi,
You can change the axis to be categorical rather than time series. Right click chart and choose Chart Options. On the scale tab set the x axis scale to Category. Excel charts can appear difficult but they can be and are very versatile. Have a look at these sites for charting tips, tricks and work arounds. http://peltiertech.com/index.html http://www.oaltd.co.uk/Excel/Default.htm http://www.tushar-mehta.com/ www.stfx.ca/people/bliengme http://www.edferrero.com http://www.datapigtechnologies.com/ExcelMain.htm http://www.prodomosua.it/ppage02.html Cheers Andy John wrote: Is there a way to have excel not graph a space in between dates that are not right in a row... for example. if I have 12-1, 12-2, 12-3, and then jump to 12-6.... how can I avoid that space in my graph. also... I find excel graph's to be difficult to work with... are there any recomended charting programs that work with excel that have more functionality and just work better? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates and Recomended Graphing Programs to work with excel?
Thanks Andy!
"Andy Pope" wrote: Hi, You can change the axis to be categorical rather than time series. Right click chart and choose Chart Options. On the scale tab set the x axis scale to Category. Excel charts can appear difficult but they can be and are very versatile. Have a look at these sites for charting tips, tricks and work arounds. http://peltiertech.com/index.html http://www.oaltd.co.uk/Excel/Default.htm http://www.tushar-mehta.com/ www.stfx.ca/people/bliengme http://www.edferrero.com http://www.datapigtechnologies.com/ExcelMain.htm http://www.prodomosua.it/ppage02.html Cheers Andy John wrote: Is there a way to have excel not graph a space in between dates that are not right in a row... for example. if I have 12-1, 12-2, 12-3, and then jump to 12-6.... how can I avoid that space in my graph. also... I find excel graph's to be difficult to work with... are there any recomended charting programs that work with excel that have more functionality and just work better? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|