|
Is there a way to generate Excel spreadsheets with Perl on Linux so that I can open the spreadsheet on Windows and it creates native Excel graphics? I know that there are libs to draw graphics but all libs I know simply insert a picture to the Excel which...
Started by Andrew Senin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
See, the following sub-document on Spreadsheet::WriteExcel Charts and the....
Yes, Spreadsheet::WriteExcel has a embed_chart($row, $col, $filename to insert charts from existing files (with some caveats).
Try Spreadsheet::WriteExcel.
|
|
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.
|
Ask your Facebook Friends
|
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 ....
|
|
When Excel determines the axis values it will use to represent your data in a chart, the values are 'evenly distributed'.
For Example: If you plot the following series in an Excel Line Chart. [0.22,0.33,0.44,0.55,0.66,0.77,0.88,0.99,1.1,1.21,1.32,1.43...
Started by Burmudar on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
After doing some experiementing, I conclude that Excel:
1.
Please have a look at:
http://stackoverflow.com/questions/611878/reasonable-optimized-chart-scaling
There are more questions like this.
|
|
I am amazed and dumbfounded to find out that a report generated in Microsoft Access will not include the charts I generated when exporting to Excel, Word or any other technology.
Has anyone found a work-around for this? My user base needs to be able to...
Started by cLFlaVA on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Have you tried the "Publish It to Microsoft Word" or "Analyze it with Microsoft Excel.
The graph, etc.).
|
|
I am reading this article:
http://www.juiceanalytics.com/writing/bubble-trouble/
I would like to make a chart that looks like the bubble one in Excel.
Is VBA a requirement?
Can anyone help me to start?
Started by alexluvsdanielle on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
Like the bubbles, this feature allows/wp/2009/01/19/excel-bubble-chart/....
I don't believe you can perform this exact graphical representation using Excel "out of the box of Excel? Version 2007 has some pretty nice looking grahics...
|
|
It is obviously possible to hide individual data points in an Excel line chart.
Select a data point. Right click -> Format Data Point... Select Patterns Tab Set Line to None How do you accomplish the same thing in VBA? Intuition tells me there should...
Started by d91-jal on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In excel a data point represented by a #N line charts from displaying 0 values for example..
Something in excel, but don't know how to do it in VBA you could just record a macro and look be controlled from the vba code as well.
|
|
I need to create a workbook which has a raw data on a sheet and a pivot table on another sheet. The pivot is created from the raw data. Then I need to create a chart with this pivot on the same or new sheet.
How can I do this in C# - and is this possible...
Started by MSIL on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
My approach was this:
Create a worksheet called "RAW DATA from Excel and refresh the "Raw data" sheet, via VBA or defining an SQL query in Pivot data source that can help you with that, even some....
The language is already built in to Excel.
|
|
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.
|