Stackedcolumnchart percentage on label depending on second axis RSS

• • Reply
  

  Froqqle

  0 Points

  1 Post

  Stackedcolumnchart percentage on label depending on second axis

  May 25, 2012 11:40 AM|LINK

  Hello,

  following problem: I'm creating a chart with this code

  <div align="center" valign="center" heigth="100%" width="100%">
      
      	<asp:Chart ID="Chart1" runat="server" DataSourceID="AccessDataSource1"
  			BackColor="Silver" Height="850px" Width="1650px"
  			AlternateText="- Das Diagramm kann nicht angezeigt werden -">
  			
  			<series>
  				<asp:Series ChartType="StackedColumn" Name="Series2" XValueMember="0"
  					YValueMembers="SOLL" YAxisType="Primary" Color=#3333FF>
  				</asp:Series>
  
  				<asp:Series ChartType="StackedColumn" Name="Series1" XValueMember="0"
  					YValueMembers="IST" YAxisType="Secondary" Color="Green" Font="Microsoft Sans Serif, 12pt">
  				</asp:Series>
  			</series>
  
  			<chartareas>
  				<asp:ChartArea Name="ChartArea1">
  					<AxisY Maximum="160" Minimum="0">
  						<MajorGrid LineDashStyle="Dash" />
  						<LabelStyle Enabled="False" />
  					</AxisY>
  					<AxisX>
  						<MajorGrid Enabled="False" LineDashStyle="Dash" />
  					</AxisX>
  					<AxisY2 Maximum="160" Minimum="0">
  						<MajorGrid LineDashStyle="Dash" />
  						<LabelStyle Enabled="False" />
  					</AxisY2>
  				</asp:ChartArea>
  			</chartareas>
  
  		</asp:Chart>
  
  		<asp:AccessDataSource ID="AccessDataSource1" runat="server"
  			DataFile="database.accdb"
  			SelectCommand="SELECT [0], [SOLL], [IST] FROM [Export]">
  		</asp:AccessDataSource>
  
      </div>

  
  The green series1 should display a label on it depending on the percental part to the direct value of the series2 next to it. Each series2 means 100% and the series1 should be the percental value.

  I hope you can understand my problem.

  Regards,

  Froqqle

• • Reply
  

  Qin Dian Tan...

  All-Star

  113532 Points

  12480 Posts

  Microsoft

  Re: Stackedcolumnchart percentage on label depending on second axis

  May 29, 2012 03:53 AM|LINK

  Hi,

  I guess you can calculate the data in the datasource of Chart, not doing this in Chart.

  Thanks,

  Please mark the replies as answers if they help or unmark if not.
  If you have any feedback about my replies, please contactmsdnmg@microsoft.com.
  Microsoft One Code Framework