rikklaney1
Registered User.
- Local time
- Today, 05:18
- Joined
- Nov 20, 2014
- Messages
- 157
Morning all,
I've been asked to import some excel graphs to display on an access form. I haven't found a way to link to the actual graphs in the spreadsheet so I linked to it as a table. I am trying to recreate the graphs in access but what I want to know is if there is any way to conditionally format an access graph the way you can in excel? I.E if value is less than a target value then that bar is red else that bar is green. I have found no way to do this so far. Alternatively is there a way to just link to the chart in the excel spreadsheet and display that?
I've been asked to import some excel graphs to display on an access form. I haven't found a way to link to the actual graphs in the spreadsheet so I linked to it as a table. I am trying to recreate the graphs in access but what I want to know is if there is any way to conditionally format an access graph the way you can in excel? I.E if value is less than a target value then that bar is red else that bar is green. I have found no way to do this so far. Alternatively is there a way to just link to the chart in the excel spreadsheet and display that?