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.

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" <cr113@hotmail.com> wrote in message 
news:60a1f156-089b-4d1d-b2b9-88c5f87aff91@g19g2000yqe.googlegroups.com...
> 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. 

On Mar 24, 10:51=A0pm, "Al Campagna" <newsgro...@comcast.net> wrote:
> cr113,
> =A0 =A0 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.

> =A0 =A0 Same with the line object.
> =A0 =A0 You can even control the location, if needed, by adjusting the la=
bel's
> Top/Left, and the line's Top.
> --
> =A0 =A0 hth
> =A0 =A0 Al Campagna
> =A0 =A0 Microsoft Access MVP 2007-2009
> =A0 =A0http://home.comcast.net/~cccsolutions/index.html
>
> =A0 =A0 "Find a job that you love... and you'll never work a day in your =
life."
>
> "cr113" <cr...@hotmail.com> wrote in message
>
> news:60a1f156-089b-4d1d-b2b9-88c5f87aff91@g19g2000yqe.googlegroups.com...
>
>
>
> > 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 q=
uoted text -
>
> - Show quoted text -

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" <cr113@hotmail.com> wrote in message 
news:261799c1-0579-4958-bd6e-0734545daf9e@l25g2000yqd.googlegroups.com...
On Mar 24, 10:51 pm, "Al Campagna" <newsgro...@comcast.net> 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" <cr...@hotmail.com> wrote in message
>
> news:60a1f156-089b-4d1d-b2b9-88c5f87aff91@g19g2000yqe.googlegroups.com...
>
>
>
> > 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 -