473,382 Members | 1,646 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

How to save chart properties in xsl file ?

Hi,

We have developed an application that transforms xsl into excel file and
present xsl file to the user with data. We use open xml features of excel
2003. Our user is now asking for a chart to be part of transformed xl file.
We tried to save the chart properties in the xsl and it is not saving the xsl
with chart properties ( chart we are trying is simple pie chart)

Appreciate if any one has a solution or idea for this to happen.

Regards
SM

Apr 10 '07 #1
1 1611
You could open an existing Excel file that contains a chart and modify it as
an ADO.NET data source:
http://groups.google.com/group/micro...1439ff12d7473d

Or here are some other ways to create Excel output:
http://SteveOrr.net/articles/ExcelExport.aspx

Here's a free control that can help with Excel output (and Word, PowerPoint,
and WordPerfect output):
http://SteveOrr.net/articles/ExportPanel.aspx

And here are a couple good 3rd party products that can make your chores
easy:
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"SM" <SM@discussions.microsoft.comwrote in message
news:E8**********************************@microsof t.com...
Hi,

We have developed an application that transforms xsl into excel file and
present xsl file to the user with data. We use open xml features of excel
2003. Our user is now asking for a chart to be part of transformed xl
file.
We tried to save the chart properties in the xsl and it is not saving the
xsl
with chart properties ( chart we are trying is simple pie chart)

Appreciate if any one has a solution or idea for this to happen.

Regards
SM
Apr 11 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jim | last post by:
I have this chart on a form. I'm trying to get this chart to render only if the user chooses to do so. This because of that the chart is quite complex and takes some time to render. I know that I...
22
by: PeteCresswell | last post by:
I've been to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mschrt/html/vbobjtitleobject.asp, but still don't have a clue. For example, I've got a chart object namde...
1
by: Chris Ward | last post by:
Capture a client window and save as a file (bmp), WindowsXP platform. Does anyone know how to go about doing this with Managed C++ v7.1? Maybe GDI+? DirectX? IdeasVacuum
8
by: LB | last post by:
Hello everybody I'm learning how to create pie chart using OWC. I'm able now to create a pie. But I can not figure out how to do the following : - for each pie, when mousing over, I would like...
1
by: keliie | last post by:
Hello, I've created a form that contains a single unbound combo box and two subforms. The two subforms display the results of a query (driven by the combo box selection) in both tabular and...
8
by: dkelly | last post by:
I wish to create a report with a chart, but I want to use a SQL statement as the source of the data, using VBA code in the reports load event I found the following snippet Dim objGraph As...
0
by: G Gerard | last post by:
Hello I have a graph in a report that is has the following properties: OLE Class - Microsoft Graph 2000 Chart Class - MSGraph.Chart.8 On some computers this graph does not work. I suspect...
2
by: DaveD170 | last post by:
Hi everybody, I'm newbie in c# and I'm having trouble in creating an excel chart. I have vector of data that my program calculated. It's in the next format: X Y 0.1 100 0.2 90...
10
by: dbdb | last post by:
Hi, i create a chart in ms access based on my query, then i want my chart when is it open is only show value based on my criteria. i'll try to used it in the properties apply filter using the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.