How to Rotate 2D MSChart so bars are Vertical?

[Thom]

Hi All! I've been developing a test for new employees at my company, and when they finish it I want a Chart/graph that show the max score(20) as a vertical bar going from Left to Right, and then a bar showing the user's score as another bar below the first one, showing their score. I can't find anywhere in MS help how to do this. Is it even possible?

You could use two rectangle shapes and adjust the width.

lblMaxScore.Text = "Total Possible: 20"
shpMaxScore.Width = 8055 ' Or whatever you want the max width to be
lblUserScore.Text = "Your Score: " & UserScore
shpUserScore.Width = (UserScore / 20) * shpMaxScore.Width ' Figure the percentage of the Score and convert the width of the box

------------------
Boothman

There is a war out there, and it is about who controls the information, it's all about the information.

[Thom]

THANKS Boothman! I ended up doing something very similar to what you sent. I guess I just needed to have my suspicions about MSCharts weakness confirmed.