I have an XY chart using dates for the X. The Y axis is made up from a
column of equations. When I create the chart, the lines that connect the
data points don't show up. I have been into the plot format and tried making
the lines come up in different colors, but nothing seems to work. However,
when I make a column that is equal to just the value of the other cells and
use this new column to graph the chart, the lines show up, but the dates
change to numbers between 0 and 12 on the chart. How do I make the lines
show up without changing the any of the data?

Can you give an example of how your data is set up?
no lines indicates the possibility of non-contiguous data.
when you changed changed the columns to data did you change both the X and Y
value columns?
When you look at Chart sourse data, what does it show for the X and Y data
fields?



"Vas" wrote:

I have an XY chart using dates for the X. The Y axis is made up from a
column of equations. When I create the chart, the lines that connect the
data points don't show up. I have been into the plot format and tried making
the lines come up in different colors, but nothing seems to work. However,
when I make a column that is equal to just the value of the other cells and
use this new column to graph the chart, the lines show up, but the dates
change to numbers between 0 and 12 on the chart. How do I make the lines
show up without changing the any of the data?