Computing.Net > Forums > Office Software > Excel 2007 data bars for Excel 2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel 2007 data bars for Excel 2003

Reply to Message Icon

Name: jared511
Date: August 24, 2009 at 04:35:50 Pacific
OS: Windows Vista
Product: Microsoft Excel 2003 (full)
Subcategory: Microsoft Office
Comment:

Is their any addin or is it possible to use data bars in excel 2003 similar to the ones you can conditionally format in 2007?


Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: August 24, 2009 at 10:25:59 Pacific
Reply:

There is no Data Bars that I know of, but you can use the =REPT() function to get something close.

MIKE

http://www.skeptic.com/


0

Response Number 2
Name: Mike (by mmcconaghy)
Date: August 24, 2009 at 10:39:13 Pacific
Reply:

Here's a VBA solution that I just came acoss:

http://datapigtechnologies.com/blog...

MIKE

http://www.skeptic.com/


0

Response Number 3
Name: jared511
Date: August 24, 2009 at 11:10:09 Pacific
Reply:

Awesome thanks!


0

Response Number 4
Name: Mike (by mmcconaghy)
Date: August 24, 2009 at 14:37:50 Pacific
Reply:

Glad I could help.

MIKE

http://www.skeptic.com/


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel 2007 data bars for Excel 2003

Using Text as a Data source for formatting www.computing.net/answers/office/using-text-as-a-data-source-for-formatting/9326.html

Excel 2003 VBA code for filtering www.computing.net/answers/office/excel-2003-vba-code-for-filtering/8353.html

Mail merge from Excel 2003 gives error messag www.computing.net/answers/office/mail-merge-from-excel-2003-gives-error-messag/9173.html