Link to home
Start Free TrialLog in
Avatar of new_crystal
new_crystalFlag for United States of America

asked on

Customize the graphs by only 1 legend, custom line value etc

I have 10 graphs in a report, i want to add following features to it:
1) i want to have only 1 legend for 12 graphs at the top.
2) i have a custom line at 2, i need to write '2' next to that line on Y-Axis
3) i am not able to rotate the x-axis values in an angle, by default they are displayed in 45 angle. I want to display them in 90 angle. if change it to 90...it doesnt change the rotation.
4) is it possible to add a dotted vertical line in the middle of the graph? is the insert line a perfect option to do so?

Thanks in advance,
new_crystal
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
1) i want to have only 1 legend for 12 graphs at the top.
What you could do is move the legend for the first graph to the top of the chart. It will appear to be the legend for all.

2) i have a custom line at 2, i need to write '2' next to that line on Y-Axis
You can add a text box and make the text box appear in front of the chart by right clicking and move to the front. Or edit the existing text for the Y axis and add the 2 in the box there.

3) i am not able to rotate the x-axis values in an angle, by default they are displayed in 45 angle. I want to display them in 90 angle. if change it to 90...it doesnt change the rotation.
In this case you may need to make the chart a bit bigger to allow for the extra room need for 90.  

4) is it possible to add a dotted vertical line in the middle of the graph? is the insert line a perfect option to do so?
right click on the chart, goto grid.  Then goto Grids tab.  There at the bottom should be a draw custom line at section. Once you have your line in place. Right click on the new line and format accordingly.