jptu
asked on
controlling colors in a pie chart
I want to create a pie chart that uses green to represent "low" values, yellow for "mod", and red for "high". Is there a way to do this? A bar chart will do also.
Thanks,
jptu
Thanks,
jptu
I can't do nothing but give u a starting point. Assumig u r using A2K and that u name your pie chart PieChart, u could add code like the following in the Updated event of PieChart, after adding a reference to "Microsoft Graph 9.0 Object Library":
Dim g As Graph.Chart
Set g = Me.PieChart.Object
Stop
From this point on you'll have to experiment. I did try to and had to quit, but I'm sure this is the right track ...
Also, maybe asking in the Microsoft Office Topic Area(https://www.experts-exchange.com/jsp/qList.jsp?ta=msoffice) might help too ...
HTH/EQTA
T.S.U. Mario Osorio
Punto Fijo, Falcon, Venezuela
Dim g As Graph.Chart
Set g = Me.PieChart.Object
Stop
From this point on you'll have to experiment. I did try to and had to quit, but I'm sure this is the right track ...
Also, maybe asking in the Microsoft Office Topic Area(https://www.experts-exchange.com/jsp/qList.jsp?ta=msoffice) might help too ...
HTH/EQTA
T.S.U. Mario Osorio
Punto Fijo, Falcon, Venezuela
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TheNextStep- thank you! It works beautifully.
-jptu
-jptu
First of all, I have never seen pie or bar charts native to Access.
I am not saying it can't be done, but I would export my data to Excel and use the charting that is native to that app.
But if I HAD to do it in Access, I can't think of a way to make a Pie, but if I were going to create a bar chart, I would design a Report with a Frame fraBackDrop (for background contrast)
with a Width = 6"
with a BackColor = Grey
Then put 3 textboxes on it.
txtFirst, txtSecond, and txtThird and place them on the Frame in the configuration that you would like them to appear on the Report.
Then in the Report's Open code I would test the value that you want each textbox to represent, and change their Width and BackColor properties accordingly.
This was a cool one to think through! Thanks,
Mac