Excel - expanding Graphs

[jewallis]

[COLOR=rgba(0, 0, 0, 0.701961)]Hi,[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]I have a spreadsheet that contains several graphs. The graphs are from a fixed starting date to the current month. I want the graph to expand to the “current month” automatically.[/COLOR]

[COLOR=rgba(0, 0, 0, 0.701961)]The data is coming from a separate tab within the workbook, but is automatically being updated from SAP BW, so I can’t format as a table, or create range names.[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]Any ideas?[/COLOR]
[COLOR=rgba(0, 0, 0, 0.701961)]Thanks for your help![/COLOR]

 

[jewallis]

[h=4]Sorry, first time here...lets try that again![/h]Hi,
I have a spreadsheet that contains several graphs. The graphs are from a fixed starting date to the current month. I want the graph to expand to the “current month” automatically.

The data is coming from a separate tab within the workbook, but is automatically being updated from SAP BW, so I can’t format as a table, or create range names.
Any ideas?
Thanks for your help!