ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My Stock type plots get reformmated - can I stop this? (https://www.excelbanter.com/excel-discussion-misc-queries/193127-my-stock-type-plots-get-reformmated-can-i-stop.html)

steven

My Stock type plots get reformmated - can I stop this?
 
I have maybe a dozen Stock type plots. I use them for statistics - I plot
how median and 5%/95% percentiles vary over time.

Every time I add a new data point to the graph, the whole blamed thing
defaults to ridiculous settings. Then I have to go in manually to reformat
the X axis location, the color of the median data series, and the up-down
bars.

Is there any way to prevent Excel from changing the graph, or do I just have
to live with this?

TIA


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com