ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chart (https://www.excelbanter.com/excel-discussion-misc-queries/27905-chart.html)

Vas

Chart
 
I have some data, as dates and numbers. The dates I'm using as the X axis
and the numbers as the Y. When I graph the data from their original cells,
excel changes the dates to numbers between 0 and 12 and graphs the scatter
plot with the lines. When I use another set of cells to see if there is a
number in the original cells and to chart the data, the chart that is plotted
graphs the correct coordinates, but the lines connecting the coordinates are
no longer visible. How do I remedy this?


All times are GMT +1. The time now is 03:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com