Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Named Formulas in Charts | Excel Discussion (Misc queries) | |||
Can you paste formulas with no value so Charts don't registerthem | Excel Discussion (Misc queries) | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
Can I use formulas that return cell range ref. in charts X series | Charts and Charting in Excel | |||
FORMULAS IN CHARTS? xl2000 | Charts and Charting in Excel |