First off, I always get the two confused. I am referring to the X-axis as the horizontal line and the Y-axis as the vertical line.
I know that a 2nd Y-axis is possible in a chart. I have noticed that there is provision for a 2ndary X-axis label. But I can't find if it is possible to actual display a 2nd X-axis.
Here is situation:
Along the bottom x-axis are dates over a period of 3 months.
Along the left y-axis is the scorings of ServerUtilizaton (free-space). There are a dozen or more servers included in the report.
Along the right y-axis is the scorings for the number of active users per day
To make it simple, I limited it to just a single month and a single server . The resulting chart makes sense and is visually understandable. It shows the relationship between server space as opposed to the number of users logged on. When free server space was low, the number of users that day was high. Alternately, when the number of users was low, the free-space on the server was up.
The only way I can make sense of the mess of trying to add multiple servers on the same report (my supervisor's request) and to add multiple months is to find a way to design a 2ndary x-axis running along the top of the chart that splits it into each server. Then I might possibly be able to add another 2 or 3 servers to each chart and only ending up with 4 to 6 charts instead of a dozen or more.
I also know that this scenario would cause a saw-tooth-effect line between each server. And this WILL be easily misunderstood as by upper mgmt reading the stupid thing. Nonetheless, I have beat my head against the wall for several days on this and am not coming up with a solution.
I actually found that in this case it made more sense NOT to use a pivot table. After creating a pivot table the data did not make any sense whatsoever.
I'm in classes for 3 days and won't be able to check here often.
I know that a 2nd Y-axis is possible in a chart. I have noticed that there is provision for a 2ndary X-axis label. But I can't find if it is possible to actual display a 2nd X-axis.
Here is situation:
Along the bottom x-axis are dates over a period of 3 months.
Along the left y-axis is the scorings of ServerUtilizaton (free-space). There are a dozen or more servers included in the report.
Along the right y-axis is the scorings for the number of active users per day
To make it simple, I limited it to just a single month and a single server . The resulting chart makes sense and is visually understandable. It shows the relationship between server space as opposed to the number of users logged on. When free server space was low, the number of users that day was high. Alternately, when the number of users was low, the free-space on the server was up.
The only way I can make sense of the mess of trying to add multiple servers on the same report (my supervisor's request) and to add multiple months is to find a way to design a 2ndary x-axis running along the top of the chart that splits it into each server. Then I might possibly be able to add another 2 or 3 servers to each chart and only ending up with 4 to 6 charts instead of a dozen or more.
I also know that this scenario would cause a saw-tooth-effect line between each server. And this WILL be easily misunderstood as by upper mgmt reading the stupid thing. Nonetheless, I have beat my head against the wall for several days on this and am not coming up with a solution.
I actually found that in this case it made more sense NOT to use a pivot table. After creating a pivot table the data did not make any sense whatsoever.
I'm in classes for 3 days and won't be able to check here often.