Charting Dow vs. Portfolio with dates

  • Thread starter Thread starter Old Red One
  • Start date Start date
O

Old Red One

Given three columns - the date, say 30 to 90 days, the Dow Average over the
same time, and a portfolio value, how can they appear in a sensible fashion?
The Dows is about 10,000 and the portfolio is over 1,000,000, and the dates
are 7/1/04 etc. I get two very distinct lines for the first two and
gibberish for the dates. How to Handle? Please comment.
 
If you have a heading in the date column, delete it
Select a cell in the table, and click the Chart Wizard button
Create a line chart from the data
Right-click on the portfolio line
Choose Format Selected Series
 
Debra Dalgleish said:
If you have a heading in the date column, delete it
Select a cell in the table, and click the Chart Wizard button
Create a line chart from the data
Right-click on the portfolio line
Choose Format Selected Series
Click to expand...
Many thanks! Yet both lines have data points rater than being just smooth
lines. How do I get rid if the data points?
 
Select the chart
Choose Chart>Chart Type
Select the Line Chart category, and the sub-type without markers
 
Back
Top