auto-format graoh axis based on different data formats

[ExcelHottie]

I want my excel graph axis to auto-format based on what data I am bringing in – either an absolute number or a percentage. I have a drop down menu and depending on what option you choose you either get an absolute or a percentage. Based on that data I have a graph and I want the data in the graph to update automatically as I choose an option from the drop down meny - including the format of the axis. How do I do that? I work with Excel 2007.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[tusharm]

Unless you are doing something to override Excel's default choices, it automatically picks the format used in the data you are plotting.

I want my excel graph axis to auto-format based on what data I am bringing in – either an absolute number or a percentage. I have a drop down menu and depending on what option you choose you either get an absolute or a percentage. Based on that data I have a graph and I want the data in the graph to update automatically as I choose an option from the drop down meny - including the format of the axis. How do I do that? I work with Excel 2007.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>