• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

HELP !!!MSGraph Help

When using MSCHART how do I create a pie graph exactly for 100 percent and a bar graph with only 5 different bars with its legend.
0
dipen
Asked:
dipen
1 Solution
 
mark2150Commented:
A 100% pie graph is a closed circle!

MSCHART has many drawbacks including being more-or-less impossible to print. Draw your own bars and such. Here is an example showing a double barchart for disk free space

'
With MSChart1
'
' Set up basic barchart
'
        .chartType = VtChChartType2dBar
        .Row = 1
        .ColumnCount = 0
                disksize = (insert your data here)
                diskfree = (ditto)
'
                    .ColumnCount = .ColumnCount + 1
                    .Column = .ColumnCount
                    .ColumnLabel = UCase$(Drive1.List(Drive)) + vbCrLf + LTrim$(Str$(Int(diskfree / disksize * 1000 + 0.5) / 10)) + "% " + LTrim$(Str$(Int(diskfree / 1000000))) + "/" + LTrim$(Str$(Int(disksize / 1000000))) + "Mb"
                    .Data = Int(diskfree / disksize * 1000 + 0.5) / 10
'
        .Refresh
    End With
'

0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now