I'm trying to create a dynamic range graph by a specific column.
How to find a way for a chart to display three columns of data but to control how many cells are filled in column 'D'.
I manage to display all the data, but I cannot control the column. Am I wrong in the OFFSET function somewhere?
btw: I want to create a chart in 6 days but all three columns should be displayed on the 'X' axis.
Please see attached a simple example.
How to find a way for a chart to display three columns of data but to control how many cells are filled in column 'D'.
I manage to display all the data, but I cannot control the column. Am I wrong in the OFFSET function somewhere?
btw: I want to create a chart in 6 days but all three columns should be displayed on the 'X' axis.
Please see attached a simple example.