Automatically resize chart horizontal values when adding new data

[worthm]

Hello,
I'm using Office 2010. Each day I add new data to some charts on my dashboard. At the beginning of the month the horizontal values are from 0 to 10, then 0 to 20, 0 to 50, 100, etc. I have to manually change the value range on the chart. Is there a way to make this change to match the values on the table where the chart gets its data?

Thanks in advance

[tuph]

It sounds as though the Axis Options for Minimum and Maximum have been set to a specific number. Try changing this setting to Auto.

[worthm]

Hey TUPH, that's an amazingly simple solution! Thank you!