Posted: 7/1/2016 8:17:37 PM EDT
|
Google can't help me on this one...
I have a chart in Excel (2010), simple line graph, x axis is date. How can I have it so the x axis is only the dates I input (have data for)? At the moment it is adding dates between my data points, I don't want it to do that, I want it to only plot the graph according to the dates I put in- even if they are not evenly spaced (ie I get the data about once a week- but it may not be on the same day of the week). |
Just so I understand, you want it to look like this?
I collect data for every working day from different departments and compile it; so I don't count weekends or holidays. If this is what you're looking for shoot me a message and I will send you a template for it. |
|
How much leeway do you have with the data? 1. transform the date field to a text field: = MONTH( C6 ) & "-" & DAY( C6 ) & "-" & YEAR( C6 ) 2. choose chart type "Line", not "XY" edit: even easier way, thanks ncoday. (It isn't under format axis for me. I'm on Excel 2003 at home. Method may be different for 2007 and up, but you should be able to find it somewhere.) go to chart options --> Axes --> choose categorical instead of auto |