RE: one more tweak to the bar chart legend

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Karl-

I tried inserting the Chr(13) & Chr(10) in place of the &"-"& in my row
source and the bar chart legend text is still on the same single line below
the bars instead of two lines... just a space a couple of characters wide "
" instead if the "-"

I also played around with decreasing the font size from a bold 8.5 to a 6
normal but this did not make a difference other than the text was smaller and
not as thick...

is there something else that I need to set up on the chart itself for these
to display as two lines?

"KARL DEWEY" wrote:

([Assembly Number] & Chr(13) & Chr(10) & Left([IDESC],10)) AS Expr1,
--
KARL DEWEY
Build a little - Test a little


"Jeff" wrote:

thank you Karl Dewey for helping me combine two fields in a bar chart legend,
but is there any way to insert a new line instead of a hypen seperationg
these two fields so that the part number is on one line under the bar and the
description is on another line?

I am finding that it is great to have this info but the bar chart is getting
squished or the fields are getting cut off.

thanks

---------------------------
SELECT TOP 10 ([Assembly Number] &"-"& Left([IDESC],10)) AS Expr1,
(Sum([Pass Quantity])/(Sum([Pass Quantity])+Sum([Fail Quantity]))*100) AS
[FPY by Operation] FROM [metrics problem qry] GROUP BY ([Assembly Number]
&"-"& Left([IDESC],10)) HAVING (((Sum([metrics problem qry].[Pass
Quantity]))>0)) ORDER BY ((Sum([Pass Quantity])/(Sum([Pass Quantity])+
Sum([Fail Quantity]))*100)), ([Assembly Number] &"-"& Left([IDESC],10));

.

Relevant Pages

  • RE: one more tweak to the bar chart legend
    ... "Jeff" wrote: ... source and the bar chart legend text is still on the same single line below ... "KARL DEWEY" wrote: ... I am finding that it is great to have this info but the bar chart is getting ...
    (microsoft.public.access.reports)
  • RE: one more tweak to the bar chart legend
    ... Maybe is it a limitation with the chart features within Access where only one ... "KARL DEWEY" wrote: ... source and the bar chart legend text is still on the same single line below ... I am finding that it is great to have this info but the bar chart is getting ...
    (microsoft.public.access.reports)
  • RE: one more tweak to the bar chart legend
    ... KARL DEWEY ... "Jeff" wrote: ... but is there any way to insert a new line instead of a hypen seperationg ... I am finding that it is great to have this info but the bar chart is getting ...
    (microsoft.public.access.reports)
  • one more tweak to the bar chart legend
    ... thank you Karl Dewey for helping me combine two fields in a bar chart legend, ... I am finding that it is great to have this info but the bar chart is getting ...
    (microsoft.public.access.reports)