Solved

asp.net pie chart  -> dynamic title from db?

Posted on 2014-03-07
6
951 Views
Last Modified: 2014-03-24
Hi  all,

I'm using the below asp.net vb.net pie chart code.  It's all fine except for two things:

1. How do i dynamically assign a field from the sql database to the title of the pie chart?  As you can see I have an X where I'd like a field called 'theDate' to be inserted, how do i do that?

2. the BackImage property is a transparent 1x1px gif...  however, when applied to the pie chart as below i only get a solid white background and not transparent as expected - any ideas why?


            <asp:Chart ID="Chart1" runat="server" Width="676px" Height="410px" 
                       BackImage="../img/spacer_clear.gif" BackImageTransparentColor="White" 
                       DataSourceID="srcWBUsage_ByDate">
                <series>
                    <asp:Series Name="Series1" ChartType="Pie" Legend="Legend1" XValueMember="name" YValueMembers="percent"></asp:Series>  
                </series>
                <chartareas>
                    <asp:ChartArea Name="ChartArea1">
                        <Area3DStyle
                            rotation="10"
                            Perspective="10"
                            Enable3D="true"
                            Inclination="15"
                            IsRightAngleAxes="false"
                            WallWidth="0"
                            IsClustered="false" />
                        <AxisY IsLogarithmic="true" />
                    </asp:ChartArea>
                </chartareas>
                       <Legends>
                           <asp:Legend Name="Legend1">
                           </asp:Legend>
                       </Legends>
                       <Titles>
                           <asp:Title Name="Title1" Text="Chart Date: X">
                           </asp:Title>
                       </Titles>
            </asp:Chart>  

Open in new window


Thanks,
0
Comment
Question by:ErinTheCoderGirl
  • 3
  • 2
6 Comments
 

Author Comment

by:ErinTheCoderGirl
ID: 39914324
Any ideas in how I can assign a chart title from the database?
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 39914368
Hi,
which .Net Framework version?
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39914523
You can write code in code behind to get the field from DB and then use something like

Chart1.Titles(0).Text = Field
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:ErinTheCoderGirl
ID: 39915175
Hi, I'm using version 4.
0
 

Author Comment

by:ErinTheCoderGirl
ID: 39915555
Codecruiser - I'm not able to just implement that vague answer, do you have a link to an article I can reference and learn from?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39940190
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now