Forum Discussion
Solved
How to maintain chart formatting when altering the data range each month?
I'm working with numerous charts that are formatted with part column (# data) and part line (% data). Each month, new data is entered into the source spreadsheet. When selecting the appropriate dat...
Hello,
what do you mean with "if not in consecutive cells"? Do you want to plot from a start month, then leave a gap?
When you select the chart, the data is highlighted. You can drag the sizing handles of the highlights to change what data is charted.
Hello,
what do you mean with "if not in consecutive cells"? Do you want to plot from a start month, then leave a gap?
When you select the chart, the data is highlighted. You can drag the sizing handles of the highlights to change what data is charted.
That's perfect - thanks so much!