|
I've been using Apache POI to create and modify Excel spreadsheets, but I'm wondering if there is a way (even if it's with a different library, preferably open source) to create charts in Excel in the new xlsx format. It looks like POI has an HSSFChart...
Started by Jeff Storey on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
That....
An option may be to create the charts beforehand and use POI to write the values where the chart can read them.
You can try SmartXLS for java ,it support create/edit Excel Charts in both xls yet either.
It out to disk.
|
|
I was trying to chart some RTD data and accidentally ended up with hundreds of charts on the same worksheet. Now I'm trying to undo my error and remove all of the charts but I'm not having much luck with it.
I recorded a macro where I deleted one of the...
Started by Shaka on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Try this, it will get rid of all charts.
Try accessing the charts by index using ChartObjects(i) instead.
It's quite possible you are attempting to access a chart by name which no longer exists.
|
|
Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. But although graphs look easy...I'm still looking.
Update...
Started by Mike on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at superuser):
This is not a very practical answer (and not Excel-specific), but in terms of graphical excellence to other top Excel sites Active comments board Hopefully you'll find it interesting to, but for me it'll be the first port of call ....
|
Ask your Facebook Friends
|
Hi,
I've got a spreadsheet with plenty of graphs in it and one sheet with loads of data feeding those graphs.
I've plotted the data on each graph using
=Sheet1!$C5:$C$3000
This basically just plots the values in C5 to C3000 on a graph.
Regularly though...
Started by kevfuzz on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use something like the following this procedure to a button and click it to refresh your chart once you update the cell containing the last a formula directly within ....
You can set the range for a chart dynamically in Excel.
|
|
Hi all,
Seems a known problem, but unfortunately I've run in to it and can't find a solution..
I'm looking for a generic method to force a chart refresh/screen update during macro operation
I have an Excel worksheet with several charts and a 'selection...
Started by wimfrits on
, 11 posts
by 3 people.
Answer Snippets (Read the full thread at com):
If I remove a significant amount of Excel formulas in the workbook (not related to the chart contents item is entered in the....
It's only during code execution that charts are not refreshed
2.
This value in the Excel workbook.
|
|
Hi all,
Seems a known problem, but unfortunately I've run in to it and can't find a solution..
I'm looking for a generic method to force a chart refresh/screen update during macro operation
I have an Excel worksheet with several charts and a 'selection...
Started by wimfrits on
, 11 posts
by 3 people.
Answer Snippets (Read the full thread at vbforums):
If I remove a significant amount of Excel formulas in the workbook (not related to the chart contents item is entered in the....
It's only during code execution that charts are not refreshed
2.
This value in the Excel workbook.
|
|
Can anyone suggest some best options to include charting feature in my ASP.NET pages ? I am using VS 2008 . I would like to have charts like google analytics charts
Started by Shyju on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
For nice Flash charts with ASP.NET integration check out.
If you are using JQuery, then you could do worse than for charts and MS charts are static.
With Dundas Chart in the past and thought it was great.
|
|
Hi everybody,
As the subject states, I'm trying to paste an unlinked chart from Excel to power point (2010). I haven't been able to do so, this is what I have up to now. I have accomplished to paste the charts but no pastespecial code allows me to keet...
Started by manucho9 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at windowssecrets):
Thanks for the reply Gary!!
Regards.
Brian in Austin, Texas
If TypeName(ActiveChart) = "Chart but the charts doen't look as pretty and editing them takes a lot of time...
And not be linked to the excel file.
|
|
We have a ASP.NET C# web application and are trying to find a way to combine data/tables and charts that can be exported a single PDF.
Some things we're looking for...
The ability to export a single PDF that includes charts, tables, etc. The ability to...
Started by ThoseDarnKids on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Pretty charts, not difficult to learn.
DevExpress XtraReports for just what you're describing.
|
|
What I'd like to accomplish is to present charts on webpages. For example aspx pages gridviews that present a two column table are able to be copied & placed into Excel then a chart created. The pages I currently use most are ASP.NET 3.0 or SharePoint...
Started by Catto on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
Provides many common chart types–including line, bar, area and pie charts
Look no furtherSo you want to maybe export the GridView to MS Excel which should I can imagine contain a generated macro to generate the chart on the....
|
