January 2, 2019
WebWORQ Chart Tips
When you upgrade from WebWORQ5 to WebWORQ16 you may notice that your charts don’t render. This is an easy thing to fix and we will tell you how to do that. However, you may be wondering why they aren’t rendering in the first place. Overall, WebWORQ16 is an improved product. It has been updated to take advantage or current web technology and, perhaps more importantly, WebWORQ16 renders Excel reports more faithfully than WebWORQ5. The overall layout requires less tweaking for reports to render correctly on the web, but it also changed the way we deal with charts. WebWORQ5 uses a certain code library that was created by Microsoft a while back specifically for rendering Excel charts on the web. It hasn’t been supported by Microsoft I quite some time, so we can no longer use it.
Modern web browsers take advantage of SVG graphics. We won’t go into the details of what SVG is, but, suffice to say, when you see a chart on a web site SVG graphics are involved and WebWORQ16 is no different.
When you create a chart in Excel, it assumes certain default values. These include title font and size, y-axis scaling, series colors among others. Since the new chart rendering does not know that the chart came from Excel we need to give it the details it needs to render correctly.
Getting your charts to render is simply a matter of opening the workbook that contains the graph in Excel and explicitly setting those values. We have found that the most common elements that need to be set are title, y-axis scaling and series colors. In Excel 2013 and later open the workbook and do the following:
Select the title and give it an explicit font name, size and color
Select each of the series by right clicking on it and selecting “Format Series”
- You should see a panel on the right
- With “Line” selected, click on the paint can icon
- Change the color value and then change it to whatever color you want it to be on the report. If you are happy with the default color change it something else and then change it back so that Excel will explicitly set the value.
Select the Y-axis
- You should see the panel on the right
- Click on the bar graph icon.
- In “Axis Options” can set the bounds. They are probably set to the values you see in the graph (0 – n). Set them to the values you want. If you are happy with the default values, set them to something else and then set them back again so that Excel explicitly sets them.
- Do the same thing for “Units”. (Only major units will be displayed on the web)
Save the file
These steps cover most instances, but you may want to tweak other settings so that things look exactly the way you want. If there is something you would like to see in your charts that we are not providing you are welcome to contact QueBIT support (firstname.lastname@example.org) and we will accommodate you.