raven_squire
Board Regular
- Joined
- Jan 13, 2013
- Messages
- 99
Hello,
I have a scatter graph that contains one series and the data is located in a large table ("Format as table").
- I need to break down the contents of the graph into multiple series based on the contents of one column. Can I use some kind of “if” statement to minimise configuration and ensure that the graph is not thrown out by someone setting a filter? For example set the series axis values to the table column range where a second column contains "text"?
- I need to provide a method of selecting what series are shown. 40 odd series stacked on top of each other will be meaningless. The end user also needs to isolate certain series that contain anomalies. Can I use a slicer on a not pivot table?
Any ideas will be appreciated.
Steve
I have a scatter graph that contains one series and the data is located in a large table ("Format as table").
- I need to break down the contents of the graph into multiple series based on the contents of one column. Can I use some kind of “if” statement to minimise configuration and ensure that the graph is not thrown out by someone setting a filter? For example set the series axis values to the table column range where a second column contains "text"?
- I need to provide a method of selecting what series are shown. 40 odd series stacked on top of each other will be meaningless. The end user also needs to isolate certain series that contain anomalies. Can I use a slicer on a not pivot table?
Any ideas will be appreciated.
Steve
