I've been reading up on charts and visualizations, and there is a school of thought which discourages the use of pie charts for being hard to read and understand. I think this demonstrates many of the points made.

The discrepancy in the start amount is me trying to learn formulas as well as graphing.. It should be $15,100. The total DCA investment is also $15,100, with the investment on the first of the month. I mistakenly assumed that having the x axis dates on the first of the month was sufficient, but will keep that in mind for the next time.

The chart is skewed due to ignorance, not intention. I'm not advocating for DCA, just learning how to make graphs in Excel and picked two metrics which in this case are not appropriate. In any case the feedback I'm getting is really helpful. I think I will try charting a mature company as you suggested although it might be hard to pick a random start point.

Ok I gotcha. I'm a little slow on the uptake since I'm just getting into this. I'm now trying to figure out the best way to get the annual averages in my chart. Anyway, thanks for all the guidance.

I just looked up Value Averaging and it suggests investing more when the stock is going down and less when it's going up. I'm curious about your approach.

I may try to chart your suggestion. Since I'm new at this, I was trying to figure out how DCA affects your investment, but as others wrote, if the stock only goes up LS will win every time. I just learned what is obvious to more experienced people. Edit:. Is there a real world way to make a fair comparison? Your method only works in hindsight.

Newbie here. Can you explain?

Source: https://finance.yahoo.com/quote/TSLA/history?period1=1280620800&period2=1674950400&interval=1mo&filter=history&frequency=1mo&includeAdjustedClose=true

Made with Excel

The previous post about Tesla stock got me thinking about the different possible investment strategies.

Thanks for your compliments, but I am a beginner at making graphs and I learned a lot from making this. I used Excel. I was just lucky that the right side axis label works for both the population in millions and the number of bands.

I was very interested in your chart because it gave me a chance to think about how I would present it based on some of the feedback you got. Here is my version presented according to the three parameters.

https://postimg.cc/vgR1CqnH

https://postimg.cc/2bzqzq0P

https://postimg.cc/4nydBRqb

Edit: when I looked up the data I came up with slightly different numbers than you.

I would like to see the graph as two colored columns next to each other. It would make it easier to understand. I would also add a legend to make it even clearer. I am just starting to learn how to use Excel graphing function so I can't demonstrate it.