First let me describe what I am trying to do.
Have a "spread range" (ie. 200-325, 330-455, etc.)filled down in columns that I want to graph as a Max, Min, Mid type chart. I tried to use a =LEFT(, =RIGHT( formula to draw only the characters that I needed, however, when i did this my graph stopped reading the values. Any reason why this might happen? Or are there any possibilities that I am missing to make this easier?
I can only assume that excel cannot graph these formulas, but usually I am assed. Please help!
Thanks,
Rob
Have a "spread range" (ie. 200-325, 330-455, etc.)filled down in columns that I want to graph as a Max, Min, Mid type chart. I tried to use a =LEFT(, =RIGHT( formula to draw only the characters that I needed, however, when i did this my graph stopped reading the values. Any reason why this might happen? Or are there any possibilities that I am missing to make this easier?
I can only assume that excel cannot graph these formulas, but usually I am assed. Please help!
Thanks,
Rob