[Anonymous]

,

I don't mind exporting the data, but don't know how to export a web part. The two fields used in the graph are a date and a whole number.  I'm just looking for a solution on how to format the right y-axis to show as a percent. Not sure why you need any data or the web part to tell if that's possible and how it would be accomplished.

Lawrence

[Anonymous]

Seems to be little support for such a potentially useful tool. How about adding a suffix (%) to just the secondary Y axis? I could switch the primary and secondary y-axes but prefer not to.

[Anonymous]

Here's what I ended up doing, but again, would prefer to have % on secondary y-axis. I didn't find a way to format or add a suffix to the secondary y-axis. If anyone knows how it was done in the example, please let me know.

[Anonymous]

Hello,

  Would you mind to attach your qChartView web part and list template including the data (it doesn't have to be real data, it can be some fake numbers) and also please let me know your SharePoint and QuickApps for SharePoint version?

Thanks,

[Anonymous]

Chart Attributes
<chart caption="Real Time FCUS Document Production" xAxisName="Date" canvasBorderColor="#000000" canvasBorderThickness="1" rotateYAxisName="1" labelStep="0" baseFontColor="#ffffff" palette="3" numDivLines="10"  bgColor="#FFFFFF" showBorder="1" borderColor="#FF3300" borderThickness="3" plotGradientColor="#FFFFFF" outCnvBaseFontColor="#000000" drawAnchors="1" showToolTip="1" SYAxisName="Documents" PYAxisName="Accuracy Rate" setAdaptiveSYMin="1" is2D="1" toolTipBgColor="#000000" seriesNameInToolTip="0" yAxisValueDecimals="2" showLabels="1" labelDisplay="Rotate" slantLabels="1" placeValuesInside="1" showValues="1" showPercentValues="1" formatNumber="1" formatNumberScale="1" setAdaptiveYMin="1" showYAxisValues="1" PYAxisMaxValue="100" numberSuffix="%" />

Configuration

<Configuration>

  <Series>

    <Items FieldName="Workshop-In" AggregateFunction="Count" SeriesName="Documents to Workshop" ChartSeriesType="COLUMN" ParentYAxis="S" IncludeInLegends="true" ShowValues="true" />

    <Items FieldName="Accuracy Formatted" AggregateFunction="Avg" SeriesName="Accuracy Rate" ChartSeriesType="LINE" ParentYAxis="P" IncludeInLegends="true" ShowValues="false" />

  </Series>

  <Items FieldName="Workshop-In" AggregateFunction="Count" ChartSeriesType="COLUMN" SeriesName="Docs In" ShowValues="true" IncludeInLegends="true" />

  <XAxis FieldName="Workshop-In" SortFieldOrder="ASC" SortFieldName="Workshop-In" />

  <YAxis />

</Configuration>

ple Data from List

Workshop-In	Accuracy Formatted	Accuracy Rate	Error
1/23/2013	100	100.00%	No
1/23/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	0	0.00%	Yes
1/22/2013	0	0.00%	Yes
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No
1/22/2013	100	100.00%	No

The Sharepoint version is the free 2007 version. Web Part qChartView version 5.7 (Build 2012.3.15)

[Anonymous]

I used the screenshot to create the list and the configuration but it gave me an error.

Would you mid to export the list and the web part an attach them?

Thanks,

[Anonymous]

,

You probably need this as well:

CAML Filter

<Geq>

  <FieldRef Name="Workshop_x002d_In" />

  <Value Type="DateTime">

    <Today OffsetDays="-90" />

  </Value>

</Geq>

That's all there is except the list URL

Lawrence

[Anonymous]

Hi Lawrence,

I think that the list I created from your screenshot doesn't have the same field types and that causes a problem.

To avoid this please export your list (don't include the data if that's sensitive) and also the web part. That would give me the exact configuration.

[Anonymous]

I’ve seen this used as an example in the documentation, but I can’t find a way to make the secondary access show a percentage rather than a decimal even though the data is in percentage format.

Can anyone show me how this is done?

Here’s what I’d like the secondary axis to look like (from qChartView Help – Appendix: ple Charts)

[Anonymous]

Hello,

This is how I see the chart using the info you gave me (except for the data content, I created different set of values).

Exporting the list and the web part would help me a lot.

To export the list, go to list settings, then pick save list as template, include the content then save it to a local folder then attach it to the tread.

For the web part go to the web part verb (put the page in Edit mode, select the web part , go to the top right corner and from the menu select Export).

A web search would help too.

[Author]

Posts