Charts and formulas
 

I am trying to create a spreadsheet that imports from various servers the
total size of the drive, total free space and presents the data as a percent
of free space. This must be presentable in chart form. I tried but I can't
get the formula to work and the chart is unusable (too much data)

Charts and formulas
 

If you describe the data you're importing, and what information you want
to chart, someone may be able to offer advice.

AZ Transplant wrote:
I am trying to create a spreadsheet that imports from various servers the
total size of the drive, total free space and presents the data as a percent
of free space. This must be presentable in chart form. I tried but I can't
get the formula to work and the chart is unusable (too much data)


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Charts and formulas
 

You want to know the size of the HD in gb ormb and the free space in gb or mb
as applicable, from n number of servers and then put this in a data series
for graphic display. Is this correct?

"AZ Transplant" wrote:

I am trying to create a spreadsheet that imports from various servers the
total size of the drive, total free space and presents the data as a percent
of free space. This must be presentable in chart form. I tried but I can't
get the formula to work and the chart is unusable (too much data)

Charts and formulas
 

Here is what I have:
2A is \\server1\C$ 2B is 5.3GB (free space) 2C is 10GB (size) 2D is 53%
(%of free space) I want to import the info from the server. (Not sure how
yet) and display it as a chart.

"JLGWhiz" wrote:

You want to know the size of the HD in gb ormb and the free space in gb or mb
as applicable, from n number of servers and then put this in a data series
for graphic display. Is this correct?

"AZ Transplant" wrote:

I am trying to create a spreadsheet that imports from various servers the
total size of the drive, total free space and presents the data as a percent
of free space. This must be presentable in chart form. I tried but I can't
get the formula to work and the chart is unusable (too much data)