I use Excel very infrequently and every time I do, I have to relearn how to do things that are anything but basic. I'm trying to graph some data on a line chart and have used a column of dates for the x-axis and four other columns to generate the line graphs. Two of the columns produce graphs, but the other two columns couldn't be graphed because the source columns contained values with $ symbols at the start and sourced from a CSV file. I guess these are numbers and the graph is expecting values, but I read that Excel can do a conversion without using the VALUE function? I used formulas to strip out the dollar symbol from the data in the two columns and produce two new columns. Then I used these new columns as source data for the graph, but it still doesn't work.
This is probably a simple question easily answered and I guess I have to somehow do something to the formulas to make the graph accept the values in the cells rather than the formulas.
Bookmarks