Graphing Problems while using Text() function

[Chris Macro]

I am creating a single graph that will be reading all sorts of data based on the users selection (ie $, %, integers, etc). So I was going to use the Text() function to make my formats variable (I type in the format for each data set and link that to the TEXT function). It formats my numbers correctly, however nothing is showing up on my graph (looks as if everything is 0). I'm guessing you can't graph numbers as text? Any thoughts on a workaround for this problem?

Simplified Example of what I am doing:

D21 = 3.9
B21 = #0.00

=TEXT(D21,B21)

 

[oldbrewer]

It seems logical that you cannot plot words on a graph. Try val(text(d21,b21))

 

[Chris Macro]

That just undoes the formatting that was instated with the Text() function. According to this link it may not be possible. I might have to come up with a VBA solution to trigger the change.

 

[oldbrewer]

I am still not clear what you are trying to do. Can you give some examples of data that will be graphed please.

I made a test chart and plotted dollars, plain numbers etc and graph worked fine. If you are trying to control how the graph scale looks, you may need a series of macros that your inputters can select.