Excel/Access charting software

[william2002]

I recently posted a thread trying to compare Excel and Access and forgot to post a seocnd question. That question is: Are there any good charting "add-ons" that anyone could recommend for excel or access. Numbers are important in my analysis but a visual is more important. Certainly I would like to get whatever will give me the "best bang for the buck," so it can be free or cost hopefully no more than 100 or so.

any suggestions appreciated,
william

 

[NdNoviceHlp]

Stephen Bullen has quite a few downloads here that may be of some help. Dave
http://www.oaltd.co.uk/Excel/SBXLPage.asp#VBA

 

[william2002]

thanks Nd...anybody else know of any third party charting software?

 

[SydneyGeek]

You could check this out -- not cheap but it looks pretty comprehensive. Or this -- quite a lot cheaper. Depends what you are after...

Denis

 

[Jon Peltier]

thanks Nd...anybody else know of any third party charting software?

There are lots and most are overpriced junk. Excel has extensive charting capabilities. Describe what you need, and someone can help you do it yourself in Excel.

 

[william2002]

There are lots and most are overpriced junk. Excel has extensive charting capabilities. Describe what you need, and someone can help you do it yourself in Excel.

Basically I need to graph a horizontal histogram from a rather large collection of data. I have not decided whether to switch from excel over to acces to manipulate the data. Currently the horizontal histogram in excel tends to have gaps between bars but I need a really clean "tight" histogram that I can manipulte with color, bar size, and axis detail.

 

[Jon Peltier]

It's easy to remove the gaps between the bars. Double click on the bars, and on the Options tab, change Gap Width to zero. The other changes are also easy. In gneneral, double click on the chart element you wish to format, and switch among the tabs to find the changes you want to make.