Agent Carmichael
New Member
- Joined
- Feb 13, 2010
- Messages
- 5
I have a basic spreadsheet that I'm trying to generate 2 X-Y scatter plots from. The first graph has four lines that all use a formula for what is basically an hour count, and everything looks fine. The second X-Y scatter plot, however, is supposed to use a specific column (R) for its x-axis values. It basically calculates a cumulative percentage based off of a hard-entered cell. The formula is:
=IF(O67>0,SUM($O$19:O67)/$U$2,"")
The problem is that when I go to the second graph, which is supposed to have its x-axis values taken from that formula, the x-axis labels are the same as the first graph. Moreover, the graphs look identical, so it's not actually plotting properly. The chart type is xy scatter, and when I go to "Select Data", the horizontal axis labels actually show up as they should, with the percentages from the formulated column. Has anybody experienced this? I'm out of solutions at this point...
Side note: I used that if/then statement because the spreadsheet was designed to have more cells than will likely be needed. Because I am not the one entering the data and the collection period is not pre-determined, I assumed that was the best way to set up the cells being used for the graphs.
=IF(O67>0,SUM($O$19:O67)/$U$2,"")
The problem is that when I go to the second graph, which is supposed to have its x-axis values taken from that formula, the x-axis labels are the same as the first graph. Moreover, the graphs look identical, so it's not actually plotting properly. The chart type is xy scatter, and when I go to "Select Data", the horizontal axis labels actually show up as they should, with the percentages from the formulated column. Has anybody experienced this? I'm out of solutions at this point...
Side note: I used that if/then statement because the spreadsheet was designed to have more cells than will likely be needed. Because I am not the one entering the data and the collection period is not pre-determined, I assumed that was the best way to set up the cells being used for the graphs.