Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Chart Rotation
- Thread starter syncdba
- Start date
BobSuruncle
Technical User
You'd need 2 charts, one horizontal and one vertical.
Place these in 2 different sections, and suppress the appropriate section based on the parameter value.
For example, let's say you have a chart right now in Group Header 1.
In the SectionExpert, highlight Group Header 1.
Next, click on the "Insert" button. You now have Group Header 1 'a' and 'b'(as well as a parent Group Header 1)
Click OK to exit the Section Expert.
In your design screen, click on the Chart and copy it and then paste it into Group Header 1 b.
Right-click on the Chart and choose the Chart Expert from the shortcut menu.
On the Type tab, choose the radio button for Horizontal.
Create a string parameter with 2 values, "H" and "V".
Create descriptions for these. Turn Off the checkbox that allows editing of default values.
Back in the SectionExpert, select Group Header 1 a, and click the X-2 button beside suppress.
Use a formula similar to this:
{?YourParameterName} = "H"
Click the "Save and Close" button.
Select Group Header 1 b and click the X-2 button beside suppress.
se a formula similar to this:
{?YourParameterName} = "V"
Click the "Save and Close" button.
This ought to do the trick.
Bob Suruncle
Place these in 2 different sections, and suppress the appropriate section based on the parameter value.
For example, let's say you have a chart right now in Group Header 1.
In the SectionExpert, highlight Group Header 1.
Next, click on the "Insert" button. You now have Group Header 1 'a' and 'b'(as well as a parent Group Header 1)
Click OK to exit the Section Expert.
In your design screen, click on the Chart and copy it and then paste it into Group Header 1 b.
Right-click on the Chart and choose the Chart Expert from the shortcut menu.
On the Type tab, choose the radio button for Horizontal.
Create a string parameter with 2 values, "H" and "V".
Create descriptions for these. Turn Off the checkbox that allows editing of default values.
Back in the SectionExpert, select Group Header 1 a, and click the X-2 button beside suppress.
Use a formula similar to this:
{?YourParameterName} = "H"
Click the "Save and Close" button.
Select Group Header 1 b and click the X-2 button beside suppress.
se a formula similar to this:
{?YourParameterName} = "V"
Click the "Save and Close" button.
This ought to do the trick.
Bob Suruncle
- Thread starter
- #3
- Thread starter
- #4
BobSuruncle
Technical User
Let's clarify
1.) What is your string parameter called? Is it actually called "YourParameterName" ?
2.) Do you have a Vertical Chart in Group Header 1a (GH1a)?
3.) Do you have a Horizontal Chart in Group Header 1b (GH1b)?
How it's supposed to work:
1.) You format the Suppress property for GH1a as follows:
- {?ParmName}="V"
-This suppresses the Horizontal Chart because you chose "V" for you parameter, indicating that you want a Vertical Chart
2.) You format the Suppress property for GH1b as follows:
- {?ParmName}="H"
-This suppresses the Vertical Chart because you chose "H" for you parameter, indicating that you want a Horizontal Chart
Bob Suruncle
1.) What is your string parameter called? Is it actually called "YourParameterName" ?
2.) Do you have a Vertical Chart in Group Header 1a (GH1a)?
3.) Do you have a Horizontal Chart in Group Header 1b (GH1b)?
How it's supposed to work:
1.) You format the Suppress property for GH1a as follows:
- {?ParmName}="V"
-This suppresses the Horizontal Chart because you chose "V" for you parameter, indicating that you want a Vertical Chart
2.) You format the Suppress property for GH1b as follows:
- {?ParmName}="H"
-This suppresses the Vertical Chart because you chose "H" for you parameter, indicating that you want a Horizontal Chart
Bob Suruncle
- Status
Similar threads
- Locked
- Question
- Locked
- Question