line color
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? |
All times are GMT +1. The time now is 10:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com