one more tweak to the bar chart legend

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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));
 
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 said:
([Assembly Number] & Chr(13) & Chr(10) & Left([IDESC],10)) AS Expr1,
--
KARL DEWEY
Build a little - Test a little


Jeff said:
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));
Click to expand...
Click to expand...
 
Do not know.
--
KARL DEWEY
Build a little - Test a little


Jeff said:
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 said:
([Assembly Number] & Chr(13) & Chr(10) & Left([IDESC],10)) AS Expr1,
--
KARL DEWEY
Build a little - Test a little


Jeff said:
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));
Click to expand...
Click to expand...
Click to expand...
 
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!

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

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


Jeff said:
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 said:
([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));
Click to expand...
Click to expand...
Click to expand...
 
Back
Top