J
Jerrimiah
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
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
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
greatly appreciated