![]() ![]() For older releases, see the compatibility charts below. Palisade's latest release, 8.3.2, is supported on Microsoft Office 2013 and newer, running on Windows 8 and newer. ![]() Which software platforms or operating systems are supported by Palisade? This list includes all of our software versions, but only version 8 is currently for sale, all previous versions are supported with a valid maintenance plan only, if you have an outdated version and wish to upgrade, please email for subscription options and pricing. This article advertises compatibility specs of older and newer versions of Palisade software and Microsoft Office versions based on their release dates. But it does work for inserting.También disponible en Español: Versiones de Windows y Office compatibles con Palisade I havent tried deleting a row because didnt need it. You will have also have to set some values in your XAxis and Yaxis if you have customized the graph. Here my solution, maybe it could be useful for someone else.ġ) Keep the "old" Chart.Ranges in an object variableĢ) Keep the "old" DataSerie in an object variableĮ.getDataSeries Of course, when inserting a new row, Calc re-ranges the graphs, forgetting to include the newest row. No way, I can not "update" graphs one by one manually after locating which one was changed. One or more sheets can be updated daily or not, the cells are ordered up/botton by date, so the first row contains the later data. ![]() Both graph take the same range of data to display. I have 150 sheets in a calc document, every one with its own chart, LineDiagram and a Bar graph. Īfter several days and tries, I think I found a solution for the issue with a macro of my own. Well, I know this post is very old and I know is "Solved", but looking for a solution for my problem I got here and it seems that there wasn't a solution. The only relevant topic I found on here was this one, which is 2 years old. I tried including all the cells up to the 65,536th row as a workaround, but it ends up interpreting empty cells as zeros, which ruins everything. However, if I add data in the 15th row, it will not. If I change anything in any of those rows, the chart will update. For instance, right now I have 14 rows of data. The issue is that when I add new data (new rows), the chart does not update, because it has been given only a certain range of cells to include as part of the chart. If I change the data, the chart does update. The chart is in the same spreadsheet as the data, just on a different page. This, however, just causes Calc to display a blank graph. I also tried making the changes in Excel on another computer and then opening the file back up in Calc. Searching with Google did not help much either. I used the ideas from this page but ran into issues because OpenOffice does not display a "series" item in the formula bar when you select the graph. I've found some solutions for Excel, but they don't seem to work. Is there any way to make it automatically update? I have to edit it, select the new row, and only then does the graph update. ![]() Here's my problem: when I add a new entry, the graph does not automatically update. I've made a graph of this in a second sheet. My chart has two columns the first is a list of dates, the second is a list of income values for each day. I am running OpenOffice 3.1.1, which I believe is the latest released version, since 3.2 is still in the RC stage. Background: I'm attempting to track sales and I am making a chart of this in OpenOffice Calc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |