Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charting in PowerPoint using Excel
Hi,
I am trying to write a macro in excel that picks up data from a csv file and then updates a PowerPoint chart. The problem I have is that I need to access to fourth row and first column on the datasheet in PowerPoint and I don't know the cell reference for this cell. I know that "00" is the cell reference for the first row and first column but I need to be able to tell it to dump the data in the fourth row / first column. Can anyone help? Thanks in advance. KD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charting in PowerPoint using Excel
Hi KD,
From the help file. On the datasheet, the first column heading (starting on the left) is A, followed by B, C, D, and so on. The first row heading (starting at the top) is 1, followed by 2, 3, 4, and so on. Neither the leftmost column nor the top row has a heading. In other words, column A is actually the second column from the left; likewise, row 1 is the second row from the top. The leftmost column and the top row, which are commonly used for legend text or axis labels, are referred to as column 0 (zero) and row 0 (zero). Thus, the following example inserts the text "Annual Sales" in the top cell in column A (the second column). Range("40") Maybe the Cells(row,column) would be easier to deal with. Cheers Andy KD wrote: Hi, I am trying to write a macro in excel that picks up data from a csv file and then updates a PowerPoint chart. The problem I have is that I need to access to fourth row and first column on the datasheet in PowerPoint and I don't know the cell reference for this cell. I know that "00" is the cell reference for the first row and first column but I need to be able to tell it to dump the data in the fourth row / first column. Can anyone help? Thanks in advance. KD -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charting from excel to PowerPoint | Charts and Charting in Excel | |||
EXCEL AND POWERPOINT | New Users to Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
excel, powerpoint | Excel Discussion (Misc queries) | |||
Powerpoint charting from excel | Excel Programming |