How to show a databar in the background of a cell?

[Sascha]

Hi Syncfusion Team!

We are currently trying to display a databar in the background of a column in wpf sfdatagrid while a value is in the foreground. We want to achieve a similar representation as it is possible in Excel.

Here is an excel example.

Is this possible? If so, how?

And, additionally asked, can we also create horizontally stacked bars?

kind regards,

Sascha

[Mohanram Anbukkarasu]

Hi Sascha,   

  

Thanks for contacting Syncfusion support.    

  

Query	Solution
We are currently trying to display a databar in the background of a column in wpf sfdatagrid while a value is in the foreground. We want to achieve a similar representation as it is possible in Excel.       Here is an excel example.    Is this possible? If so, how?	You can achieve this by using GridTemplateColumn with ProgressBar and TextBlock as DataTemplate as shown in the below code example.       Code example:        <syncfusion:GridNumericColumn MappingName="Quantity"                                          SetCellBoundValue="True"                                          NumberDecimalDigits="0">        <syncfusion:GridNumericColumn.CellTemplate>            <DataTemplate>                <Grid>                    <ProgressBar x:Name="progressBar" Background="Transparent"                                           Visibility="Visible" Minimum="0" Maximum="100"                                            BorderThickness="0" Value="{Binding Path=Value}" />                    <TextBlock  Text="{Binding Path=Value}" HorizontalAlignment="Right"                                        VerticalAlignment="Center" TextAlignment="Center"/>                </Grid>            </DataTemplate>        </syncfusion:GridNumericColumn.CellTemplate>    </syncfusion:GridNumericColumn>                We have prepared a sample using the above code example and it is available in the below link for your reference.        Sample link : https://www.syncfusion.com/downloads/support/directtrac/general/ze/149391_Sample-1438457161        UG link : https://help.syncfusion.com/wpf/datagrid/column-types#gridtemplatecolumn
And, additionally asked, can we also create horizontally stacked bars?	We are not clear with this requirement. Please confirm whether you need to display as shown in the below image.                 Please provide more details about this requirement. It will be helpful for us to analyze and provide a prompt solution at the earliest.

  

 

Regards,   

Mohanram A