0

I've an excel spreadsheet with 2800+ rows of data in the form: date, $amount. The rows are from dates 1/1/2004 through 2/26/2017. Not every date is listed, but most are.

I'd like to produce a graph that shows the values at month intervals. Sure I could manipulate the data set to do that, but I know there's and easier way to get this displayed on a simple Line Chart.

3
  • Are the dates already in a certain order like per day, week or month? Feb 27, 2017 at 17:42
  • I think a normal line chart would be best for you. The changes for the difference between days in a months will be so little that you probably won't see them in the chart. Feb 27, 2017 at 17:56
  • You likely don['t want a line chart. Line charts automatically treat the horizontal axis as categorical values. You should (almost always) use an XY(Scatter) chart so your horizontal values are properly scaled.
    – dav
    Feb 28, 2017 at 12:52

1 Answer 1

0

From my answer here you can see how to get the Axis Option menu. How to make a graph of bank account data in excel with a table of balance changes?

By displaying the data chart per month you would need to select the Months units under the Axis Option. For a data with 2800+ rows it will going to look like this:

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .