Excel/Access charting software

william2002

New Member
Joined
Sep 19, 2006
Messages
6
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
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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

MrExcel MVP
Joined
May 14, 2003
Messages
5,253
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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

New Member
Joined
Sep 19, 2006
Messages
6
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

MrExcel MVP
Joined
May 14, 2003
Messages
5,253
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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.
 

Forum statistics

Threads
1,171,272
Messages
5,874,756
Members
433,070
Latest member
omartarek

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top