ElvisSteel
Board Regular
- Joined
- Mar 23, 2009
- Messages
- 122
Hi,
I have a table of data that I use to create a chart based on Location. Currently the table has 10 locations, but only 6 are currently used. The lines on the chart just drop to zero for the blank locations, and I want to use a dynamic range for this axis.
However, when I try to enter this, I get an error, and if I try to enter the dynamic range directly I also get an error.
I'm sure this must be possible, can anyone help?
Thanks
I have a table of data that I use to create a chart based on Location. Currently the table has 10 locations, but only 6 are currently used. The lines on the chart just drop to zero for the blank locations, and I want to use a dynamic range for this axis.
However, when I try to enter this, I get an error, and if I try to enter the dynamic range directly I also get an error.
I'm sure this must be possible, can anyone help?
Thanks