one more tweak to the bar chart legend

[Jeff]

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));

 

[KARL DEWEY]

([Assembly Number] & Chr(13) & Chr(10) & Left([IDESC],10)) AS Expr1,

 

[Jeff]

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?

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

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));

 

[KARL DEWEY]

Do not know.
--
KARL DEWEY
Build a little - Test a little

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?

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

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));

 

[.]

Maybe is it a limitation with the chart features within Access where only one
ine of text can be used for each legend item-

Thanks for your help!

------------

Do not know.
--
KARL DEWEY
Build a little - Test a little

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?

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


:

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));