Small Graphing Issue

[Robby87]

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

 

[RalphA]

Rob, it would help if you posted one or two specific examples, showing what is in the cells you are using in your examples, what your formula is, what you expect as a result, and what you think your problem is.

 

[Robby87]

Hey RalphA,

Thanks for answering the thread, question was already answered in another thread... Went on a crazy posting spree!

thanks anyways though.

-Rob