Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
offsetting Secondary Axes to a cell value
Hi.
Here is what i am trying to do. I am trying to create a spreadsheet that will help me graphically display the relationship between Physical harddrive space available and proposed Data chunks allocatted to a particular partition At the moment I am doing it by: Partion1+Partition2...Partion4=TotalDiskSizeAvaila ble(TDSA) Stacked bar Chart shows each partition up to my TDSA...cool I have created another series that shows the data chunks in a stacked bar chart on a secondary axes.... but i would like it to start from the end of Partition1 aligning with beginning of Partition2(where the data is allocated). Ideally i would like to change the values for the Data chunks and have it change proprtional to the size of the partition it is allocated. things I have tried: Setting the minumum axis value to minusPartition1. but the scales are different and when i change the figures it does not relate the proportion correctly. Anyhoo hope someone point me in the right direction Cheers Wai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions |