By macro interface, I mean the ability to access any component of the spreadsheet via Basic macros in a relatively painless manner. I do believe a macro needs to be written to mirror the Excel functionality in this instance. Unfortunately, of all aspects of spreadsheet programming, charting is one of my weak areas at the moment (next to pivot tables)
When you say you want the legend/data table displayed - do you mean in a popup dialog/message box or in some area of the spreadsheet. Keep in mind, the original data is there somewhere already - it's a case of just pointing to it. Dave On 10/11/05, Robert Volke <[EMAIL PROTECTED]> wrote: > David, > > What do you mean by macro interface? I haven't heard that term before > in relation to OpenOffice. Maybe there is confusion as to what my > question was. In Microsoft you had an option to display the legend > and/or the data table for a chart, and I want to duplicate this in > OpenOffice. No macros were necessary, it was built in functionality. > Do you mean that this functionality is not present in OpenOffice and I > need to use a macro to accomplish it? > > Thank you for your help. > Robert Volke > > >>> David Chapman <[EMAIL PROTECTED]> 10/11/05 2:41 PM >>> > Robert, > > In OOo Calc, if you remove original table from which chart was > created, do you not lose the chart? > > I looked at what little info I could find on macro interface to charts > - creation of chart goes like this... > > 1) Identify cell range to be charted. > 2) Create chart. > > With macro interface - it is easy to identify cell range from whence > chart was created. > > I'll play around with this this evening. > > Check "StarOFfice Programmer's Tutorial" - p74-83 > > On 10/11/05, Robert Volke <[EMAIL PROTECTED]> wrote: > > David, > > > > This link certainly goes on my list of important OpenOffice links. > I > > skimmed everything and it looks good, but unfortunately I do still > have > > one question I was hoping you could answer. Excel provides the > option > > to show the "Data Table" (a table containing the data represented by > the > > graph). Can you do this in Calc? I have spent hours looking for how > to > > do this and have been unsuccessful. Thank you, > > > > Robert Volke > > > > >>> David Chapman <[EMAIL PROTECTED]> 10/11/05 11:27 AM >>> > > Robert, > > > > I'm trying to put together tutorials for charting up to advanced > > level. > > > > Please tell me what's missing. I really want to fill the gaps... > > > > http://www.openofficetips.com/blog/archives/charting/index.html > > > > Let me know if I can help you.. > > > > Dave > > > > On 10/11/05, Robert Volke <[EMAIL PROTECTED]> wrote: > > > Does anyone know of any good references for helping with graphing > > using > > > Calc. I've skimmed over the documentation available on the > > OpenOffice > > > homepage and all of it is very basic, they don't cover any of the > > > advanced settings. > > > > > > For some background, I am currently working with version 109 on > one > > NT > > > machine and 125 on another. I am in the process of converting > > graphs > > > from Microsoft to OpenOffice and am finding it very difficult. It > > would > > > seem that they never convert over nicely. Anyway, if anyone has > any > > > suggestions please send them my way, thank you. > > > > > > Robert > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > -- > > My OpenOffice Calc Website > > http://www.openofficetips.com > > > > > -- > My OpenOffice Calc Website > http://www.openofficetips.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
