similar to: A Query

I'm sure this is a really simple problem, but I've spent hours digging and I keep running into roadblocks. I'm trying to get a simple chart with three time series. Similar to the attached example http://www.nabble.com/file/p25398419/Excel%2Bchart%2Bexample.pdf Excel+chart+example.pdf , something that was quite easy to do in Excel, except that I need a log y-axis: something that R

Hey at all I''ve a question about excel chart: i want to export some data into excel and generate a chart with different styles. unfortunately, the generated chart is in fullscreeen-mode. how can i set the size by generating the chart? does anybody know a page where i can find some information about excel charts? thanks a lot! Pascal -- Posted via http://www.ruby-forum.com/.

Hi all, Apologies if I violate any posting etiquette - this is my first submission to the R mailing list. I regularly use 'odbcConnectExcel2007' (from package 'RODBC') to read data from named ranges in excel workbooks into R. I recently received the following error message when attempting to set up a connection channel (i.e. ch1 <- odbcConnectExcel2007('path to excel 2007

I get the error, "Not enough system resources to display completely", when I zoom out below 80% on spreadsheets that have labeled charts. That is, any charts that have axis numbers, axis labels, or chart labels. If I keep the charts but delete all text, I can zoom out indefinitely without the error. If I navigate away from the chart with labels I am able to zoom out just fine. For some

hi, Thanks for responding of gantt charts. but i have some problem regarding with gantt charts. i.e. Ymd.format <- "%Y/%m/%d" Ymd <- function(x){ as.POSIXct(strptime(x, format=Ymd.format))} gantt.info <- list( labels =c("First task","Second task","Third task","Fourth task","Fifth task"), starts

Hello,   I'm trying to create an Excel chart using the package RDCOMClient. I am not able to title the excel chart and axis using RDCOMClient  "ChartTitle" and "Axis"?   Any suggestions or references is appreciated.   Thanks, uak. [[alternative HTML version deleted]]

Hi All. I'd like to programm a 4 dimensional chart in R. Acctually I wanted to solve that problem in Excel cause I had the data there. Here is a link of my actual problem description (there are some chart pictures as well).... http://www.mrexcel.com/board2/viewtopic.php?t=187336&highlight=stacked+column because I still couldn't solve that problem I came to R. The chart should be

I have a matrix with 12 rows (one for each month), 2 columns (baseflow, runoff). I would like to make a barplot similar to Excel’s “clustered column chart”. Here is my matrix ‘x’ 8.258754 13.300710 10.180953 10.760465 11.012184 13.954887 10.910870 13.839839 9.023519 11.511129 7.189241 12.519830 5.925576 17.101491 5.211613 13.585175

hi every one, i have a excel sheet like this labels starts ends 1 first task 1-Jan-04 3-Mar-04 2 second task 2-Feb-04 5-May-04 3 third task 3-Mar-04 6-Jun-04 4 fourth task 4-Apr-04 8-Aug-04 5 fifth task 5-May-04 9-Sep-04 now i converted this excel sheet into csv file and i read the csv file into R with the below code. my.gantt.info<-read.csv("C:/Documents and

I have found lots of good advice on this forum about stacked area charts but I?ve run into problems with the 2 recommended options: stackploy in plotrix or qplot in ggplot2. I have a many page report that will be in a 2x2 page format ?par(mfrow=c(2,2))?? and need one of the page components to be a stacked chart. I?d prefer to use stackpoly, if possible, but I?m stuck on how to do the legend in

Hi all, I have been hunting around for hours trying to figure out how to generate a stacked line chart using ggplot2. This type of chart can be generated in excel 2007 by selecting: Chart type > Line > Stacked line. I can generate a stacked area chart using the following code: p <- ggplot2(~, aes(x = ~, y = ~, colour = Type)) + geom_area(aes(position = 'stack', fill = Type))

Hi R-users! I'm trying to create an easy Excel chart using the package RDCOMClient. The following example is working fine: #------------------------------------------------------------------- library(RDCOMClient) xlLocationAsObject <-2 xlXYScatterSmoothNoMarkers <- 73 ex <- COMCreate("Excel.Application") wb <- ex[["Workbooks"]]$Add() sh <-

Hi, How can I attach chart/plot to a excel file? I would like to create a plot in R eg. plot(1) and save it into a Excel file, eg. test.xls in a same working directory. Regrads, -J

Hello, I have a graphics-related question: I was wondering if anyone knows of a way to create a bar chart that is colored with a three-part gradient that changes at fixed y-values. Each bar needs to fade green-to-yellow at Y=.10 and from yellow-to-red at Y=.20. Is there an option in a package somewhere that offers an easy way to do this? Attached is a chart I macgyvered together in Excel using a

> > Anyone knows if there is a way to connect R with the ERP SAP? Very big question. An ERP is an accounting system typically for a large business or governmental entity (ERP = "Enterprise Resource Planning" system). Modern ERPs are typically built on top of (multi-user) relational data base management systems (RDBMS). R has many ways to connect to relational databases -- see

If you are running on Windows you can use create and read speadsheets using the ''win32ole'' require This sample should give you the basic idea ------ def export require ''win32ole'' @sort_by = ''last_name'' current_user = ''steve'' @records = Contact.find( :all, :conditions =>

R help, How can I plot the below data table by Data ~ Site and group by Grinder and Equip Id so I get a chart like this Excel version? I have tried coplot with little success and lattice makes a pretty good chart like I want, but I am using the DCOM so it does not display correctly. I would like to make this using the base library if possible. <<...OLE_Obj...>> DATA TABLE

I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data. I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4

Dear list members, I'm using R in connection with the RDCOMClient and Excel. The more I use the package, the more I'm fascinated of it. The possibilities of R can be brought together with the necessities of outputing my socio-economical research results in MS Office! But I have some special questions concering the use of RDCOMClient and perhaps you can help me solving them: 1. Problems

Can anyone help me ??? I want to export some data into MS excel and create a pie or line chart. How can I export the data? Does it gives any tutorial websites ? thanks for your help! -- Posted via http://www.ruby-forum.com/.