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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Graphs

Status
Not open for further replies.
primagic

primagic

IS-IT--Management
Jul 24, 2008
476
GB
Anyone know how to make the axis labels the same colour as the data points in an access graph.

So if my bar chart is red, to make the referring axis label red.

 
Sort by date Sort by votes
There is a property for the font color for the series labels so this should be possible. I would build a similar graph in Excel. Turn on the macro recorder and then change the label colors. Stop the macro and copy the created code into your report section On Format event. Change the graph reference to your graph object.

Duane
Hook'D on Access
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davejam
  • Locked
  • Question
Automating graphs in a report (.maximumscale)
Replies
3
Views
29
davejam
davejam
DaverD
  • Locked
  • Question
Graphs with Time values
Replies
3
Views
54
DaverD
DaverD
FCGAccess
  • Locked
  • Question
Can Access Reports allow graphs to automatically update??
Replies
2
Views
30
dhookom
dhookom
cheech25
  • Locked
  • Question
Pie Graphs on Reprts in Access 1
Replies
9
Views
51
dhookom
dhookom
chevelleX
  • Locked
  • Question
Cant publish graphs to word (MS Office 2003)
Replies
1
Views
22
Lilliabeth
Lilliabeth

Part and Inventory Search

Sponsor

Back
Top