I have put together a table and graph in Excel 2007 to show test results on given dates, the table data has been formatted as follows:
Date column has been formatted as "Date" and Result column has been formatted as "Number".
The problem I am having is the dates on the graph are not appearing as they are in the input table shown on the left.
Untitled.jpg
I can alter the result fields and the graph automatically adjusts accordingly but nothing I change in the Date column changes when I edit the dates.
Perhaps entering these as date fields is not the right way to go??
I have tried formatting that column as text and likewise with the horizontal axis but this doesn't work either
I'm sure someone on here has come across this problem before
Many thanks
Gary
Bookmarks