Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
keeping a shape constant regardless of changes in variables
Hi all,
I need your help on the following: Column A contains dates (5 years on a daily basis), Column B has the hours (1 - 24), Column C contains the consumption and Column D contains the demand. Regardless of the shape I get when I graph it, Is it possible to always get the same shape when I change the consumption and the demand (which always will change in my case)?-I know that if consumption and demand drops then the shape is going to drop, but I still want to keep the same shape. Also, If I'm missing three months of consumption and demand, how do I set up excel so that it fills those wholes automatically and gives me the same shape? Any help will be really appreciated. Many thanks, Osvy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
How do i keep the total of 3 variables constant | Excel Discussion (Misc queries) | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Keeping variables in a formula | Excel Discussion (Misc queries) | |||
making variables constant | Excel Worksheet Functions |