Link to home
Start Free TrialLog in
Avatar of Edward Pamias
Edward PamiasFlag for United States of America

asked on

After updating data my Excel graphs are showing too many dates

All,

Strange problem, I have a graph that worked for a long time no issues, it shows an 8 week trend. For example:

11/11/16   11/18/16  11/25/16  and so on up to 8 weeks. Even tho my data I am using to graph does not show these dates I am seeing 11/13/16 11/15/16 in between 11/11/16 and 11/25/16 and so on. Any ideas?
Avatar of Brian B
Brian B
Flag of Canada image

A line/bar graph shouldn't do that. It should only show entries that match your data. If that is the case for you, check your data ranges to make sure you haven't accidentally added more columns than expected.

However if it is a scatter type of graph, Excel may put in additional axis points. You should be able to fix that by double clicking on the axis and setting that major and minor ticks as appropriate.
Avatar of Edward Pamias

ASKER

It's a bar graph.
Okay, thanks. If the information is not confidential, can you attach an example of how this isn't working?

Worst case, if it isn't to difficult to recreate the graph, it might be faster to do that rather than spend a lot of time troubleshooting.
Sorry it is confidential. I did recreate the graph I am having the same issue.
Check your axis options. It should look like this...
User generated image
If it does and it is still showing the extra dates, we will need to see a workbook from you. Save a copy with any confidential info modified prior to uploading.
Can you double click on the x axis and check what options you get? If it looks like what Wayne posted, it may not be a bar graph.

Another test, since this is supposed to be a bar graph, you column data should be like text. Can you replace your dates with letters and see what happens?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This was the best and quickest solution. Thank you all for your suggestions!