Hi,
I'm really very new to VBA, so I don't even know how to approach m
problem.

My spreadsheet is meant for various kinds of medication. Each medici
ist tested against various illnisses and then receives a rating in 1
categories. The ratings are summed up in a final cell via the =SU
function. But not each medicin qualifies for a rating and sometimes
medication won't receive any rating at all (the SUM cell stays blank.)

What I want is a macro that makes a clustered column chart from tha
data. The chart should contain every medicin whose SUM cell is no
empty. The Y-Axis (the values) is to be made up from the SUM cells. Th
X-Axis (description) should contain the corresponding medication names
Furthermore I want the columns to be sorted from highest rating t
lowest.

My main problem is that I have no idea how to do this :) . Any help i
greatly appreciated

--
Message posted from http://www.ExcelForum.com