Category:Adobe Inc.
Category:Adobe softwareQ:
Animate gridlines on chart in Excel
I am trying to animate grid lines on a chart in Excel 2007. The reason I need to animate it is because I am creating an image for a powerpoint presentation. I am able to apply the animation effect to the chart, but not the grid lines.
Here is my code to create the grid line animation effect:
Private Sub CommandButton1_Click()
Dim p As Picture
Set p = ActiveSheet.ChartObjects("Chart 1").Chart.ChartArea.PlotArea.Axes(1).LineSeries.LineSections(2).PlotRange.ChartGrouper.ChartGroups(1).AnimationOptions.Gap = "10,10"
p.Visible = False
End Sub
Ideas?
Thanks!
A:
Ugh! I have no idea why this works, but it does. Just one line of code does the trick:
p.AnimationOptions.Gap = "10,10"
Hope this helps someone else.
Q:
AWS: Cannot set "Basic Settings" of IAM User Policy on RDS
I'm trying to configure a security role to be able to access the RDS instance.
I'm using AWS Console and when creating the security group, select the "Basic Settings" and configure the "User Policy" with the following JSON code:
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"ec2:CreateNetworkInterfacePermission",
"ec2:DeleteNetworkInterfacePermission",
"ec2:DescribeNetworkInterfaces",
"ec2:DescribeVpcs", ac619d1d87
Related links: