Can you use a cell reference in a chart?

  • Thread starter Thread starter Ray & Shelley Dueck
  • Start date Start date
R

Ray & Shelley Dueck

I have a dilemna in trying to chart some data. Wondered if anyone has run
across this before.

Have data with a space instead of a comma, IE 1 555.55

I was able to add the comma by using a CLEAN and SUBSTITUTE statement in a
different column, number now displays correctly IE 1,555.55

Cannot graph, and assume that is because the cell is actually a formula
rather than a number.

So I tried using a cell reference IE "=B22" in another column, and graphing
off of that column, but still displays the same "0".

Formatting the column to a number format does not seem to help.


Appreciate any help you can offer and thanks in advance.

.................Ray
 
If the cell contains "IE 1,555.55", Excel plots it as zero, because it is
text, not a number. You need to adjust your formula to get a numeric result.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you create charts for non-adjacent columns of data in XL2007? 1
Make a calandar chart 1
Custom error bars bug -- copy pasting chart does not update refere 5
Problem creating a logarithmic trend line 2
Dynamic stacked bar chart not working 3
Dates Incorrect in Chart 5
How come when I try to insert a chart in Excel, nothing happens? 2
merged cells and creating charts 4

Back
Top