I have a graph that is displaying two series, both of which are dynamic via the Offset function.
My Offset functions are working great, and are changed using two dropdown lists. One of the options in the dropdown lists is "(none)," which the user can select if he only wants to show one series at a time.
When (none) is selected, the reference cells display "" like they are designed to.
My problem is that even when the reference cells are blank, my graph still shows it as a 0 instead of as nothing. On the select data options I clicked Hidden and Empty cells and selected "Show Hidden and Empty Cells As Gaps" which I think is the option I want?
Does anyone have any suggestions for how I can get rid of those points at 0 when (none) is selected? Any help would be greatly appreciated.
Thanks for the looks!
Hank
My Offset functions are working great, and are changed using two dropdown lists. One of the options in the dropdown lists is "(none)," which the user can select if he only wants to show one series at a time.
When (none) is selected, the reference cells display "" like they are designed to.
My problem is that even when the reference cells are blank, my graph still shows it as a 0 instead of as nothing. On the select data options I clicked Hidden and Empty cells and selected "Show Hidden and Empty Cells As Gaps" which I think is the option I want?
Does anyone have any suggestions for how I can get rid of those points at 0 when (none) is selected? Any help would be greatly appreciated.
Thanks for the looks!
Hank
