Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stevelord
Specialist
Specialist

How to add a gray box/border around a bar chart?

Hi All, I have this design request for a bar chart and am not sure how or if there is a place to do it.  (Reporting team is working to make the graphs from qlikview blend in better with graphs from other sources design-wise.)

"Is it possible to put the whole graph in a gray box? R=242, G = 242, B = 242"


Other fun fact, we just acquired nprinting.  If above is not possible in qlikview, is it possible with nprinting if I move the data onto excel or powerpoint and make those produce the graph from it?  (Such feels possible, but we're totally new with nprinting and still working our way through the basic training stuff on the design side.)

1 Solution

Accepted Solutions
maxgro
MVP
MVP

background or border?

background in color tab, background

border in layout tab (after you hoose styling mode --> advanced in menù --> settings --> document properties --> general)

1.png

View solution in original post

7 Replies
stevelord
Specialist
Specialist
Author

(nprinting question is about making a powerpoint or excel template in nprinting so nprinting can include converting the data to the desired graph design in its work.)

Not applicable

you can add borders around objects in QlikView and determine the color as well - on the layout tabl of the object check Use Borders, select the width and intesity and you can click the color and define the color you wish to use

Not applicable

regarding your nprinting question, you can bring data into the template as a table for example, and then convert the table to a chart.

see the attached link

How to Create MS Excel Charts from Qlikview Data

maxgro
MVP
MVP

background or border?

background in color tab, background

border in layout tab (after you hoose styling mode --> advanced in menù --> settings --> document properties --> general)

1.png

Not applicable

if the object in qlikview is already a chart, you can bring it into nprinting as an image of the chart, without having to go through the conversion process

stevelord
Specialist
Specialist
Author

Turned out they meant the background, so I've applied that solution.  (solid box vs hollow box. I will be sure to clarify border or background next time someone says 'box'. )  Correct and helpful answers all around.  Thanks!

Not applicable

Good to hear and glad you were able to give them what they needed

take care