Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stevelord
Valued Contributor

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
MVP
MVP

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

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

7 Replies
stevelord
Valued Contributor

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

(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

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

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

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

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

MVP
MVP

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

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

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

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
Valued Contributor

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

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

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

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

take care

Community Browser