Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unanswered NonConsecutive X Axis
I posted this earlier and never got a response, so I have added some more
detail and am reposting in hopes of solving my issue... I have a single column of data AJ11:AJ58 which contains a formula that results in OPEN or CLOSED. I need to reference this column in multiple formulas as well as in the X Axis of a chart. Not only do these values change, but they are also not necessarialy consecutive. For example, one pass results in a range of OPEN cells (which is what I need to reference) of AJ25:AJ52 and another common pass results in AJ11:AJ12,AJ21:AJ58. Is there a way to name this dynamic range so I can reference it as described? Obviously, the big problem is nonconsecutive ranges like AJ11:AJ12,AJ21:AJ58. I can't figure out how to use a range like this in an IF statement. I also tried naming those addresses as a range and then named a range that referenced it, but that didn't work... I'm running out of options and looking at a deadline - Can you say "Panic"? Thanks for your help! Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |