Can you use a cell reference in a chart?

  • Thread starter Ray & Shelley Dueck
  • 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
 
J

Jon Peltier

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

Dynamic stacked bar chart not working 3
Dynamic Vertical axis in a chart 2
Dynamic Chart Title With 3D Stacked Column Chart 2
chart to SUM mileage over months 1
XY Chart - Vertical Axis Crosses - Cell reference vs. Value 1
stacked bar chart and a bit more...Excel 2003 4
Custom Formatting a Chart Data Label 1
Excel Changing chart label colors based on a value in a cell 0

Top