excel - Display simulated data in chart -
i wondering how chart following data in line chart in excel:

in chart below, 20 simulated data points nav mo+1 20 possible values in first month in future (mo+1). next set represents 20 simulated navs in second month (mo+2).
the chart should 1 below:

problem charts end looking more this:

thanks input!
there default structures each chart defined microsoft:
http://office.microsoft.com/en-us/excel-help/select-data-for-a-chart-ha102809318.aspx
however not sufficient. better edit data source , mapping manually. described here:
http://www.dummies.com/how-to/content/how-to-edit-a-charts-data-source-in-excel-2010.html
Comments
Post a Comment