If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a label to an Access Chart
I'm using Access 2007. I want to add a horizontal line and a label to
my bar chart. Is there a way to just add a line or label anywhere on my chart? I don't want to use any of the predetermined labels like x- axis or title. I want to make my own and place it where I want. |
#2
|
|||
|
|||
Adding a label to an Access Chart
cr113,
As long as your chart appears in the same location every time the report is run... you can ue a normal label, and place in "to the front" of the chart. Same with the line object. You can even control the location, if needed, by adjusting the label's Top/Left, and the line's Top. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "cr113" wrote in message ... I'm using Access 2007. I want to add a horizontal line and a label to my bar chart. Is there a way to just add a line or label anywhere on my chart? I don't want to use any of the predetermined labels like x- axis or title. I want to make my own and place it where I want. |
#3
|
|||
|
|||
Adding a label to an Access Chart
On Mar 24, 10:51*pm, "Al Campagna" wrote:
cr113, * * As long as your chart appears in the same location every time the report is run... you can ue a normal label, and place in "to the front" of the chart. I can't get this to work. The chart always covers up the label. Maybe I'm not "placing it in front" correctly? In design mode I highlighted the label and right mouse clicked. Then I chose Postion/Bring to Front. I also tried Position/Send to Back for the Chart. Neither seems to work. * * Same with the line object. * * You can even control the location, if needed, by adjusting the label's Top/Left, and the line's Top. -- * * hth * * Al Campagna * * Microsoft Access MVP 2007-2009 * *http://home.comcast.net/~cccsolutions/index.html * * "Find a job that you love... and you'll never work a day in your life." "cr113" wrote in message ... I'm using Access 2007. I want to add a horizontal line and a label to my bar chart. Is there a way to just add a line or label anywhere on my chart? I don't want to use any of the predetermined labels like x- axis or title. I want to make my own and place it where I want.- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
Adding a label to an Access Chart
cr113,
I just revisited several charts that are currently in client use, (Access 97 and Access 2003) and I can't account for your problem. I have labels place within the graph area itself, as well as in the header/legend section, and all display with no problem. All I can suggest is... make sure you marquis the entire chart when "Sending to Back" Even though it shouldn't matter... try a transparent background for your chart. I'm sure you checked the Visible, ForeColor, BackColor, etc.. etc... for a problem... -- Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "cr113" wrote in message ... On Mar 24, 10:51 pm, "Al Campagna" wrote: cr113, As long as your chart appears in the same location every time the report is run... you can ue a normal label, and place in "to the front" of the chart. I can't get this to work. The chart always covers up the label. Maybe I'm not "placing it in front" correctly? In design mode I highlighted the label and right mouse clicked. Then I chose Postion/Bring to Front. I also tried Position/Send to Back for the Chart. Neither seems to work. Same with the line object. You can even control the location, if needed, by adjusting the label's Top/Left, and the line's Top. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "cr113" wrote in message ... I'm using Access 2007. I want to add a horizontal line and a label to my bar chart. Is there a way to just add a line or label anywhere on my chart? I don't want to use any of the predetermined labels like x- axis or title. I want to make my own and place it where I want.- Hide quoted text - - Show quoted text - |
Thread Tools | |
Display Modes | |
|
|