HI-
I have a bar chart, and one series I believe is just a normal Line series, and then I have another series that is a secondary horizontal axis. How can I add 2 more series, but change theirs to an XY-Scatter?
Thanks
HI-
I have a bar chart, and one series I believe is just a normal Line series, and then I have another series that is a secondary horizontal axis. How can I add 2 more series, but change theirs to an XY-Scatter?
Thanks
Chart question3.xlsxIf this helps, the attached has already been done, I just can't figure how to replicate. The name of the 2 series (total realized/unrealized gain), and (Total realized/unrealized loss)
I think you'd either have to change the Line chart to an XY scatter too, or plot it on the primary axis.
Remember what the dormouse said
Feed your head
Your example has the following.
Series "P&L Gain" - Column on Primary
Series "P&L Loss" - Column on Primary
Series "Dummy" - Column on Primary (but choice disabled)
Series Series "Total Realized/Unrealized Gain - XY-scatter on secondary
Series "Total Realized/Unrealized Loss - XY-scatter on secondary
If you create a chart with the frist 3 series as described you should see that "Dummy" is on secondary and choice of axis is not disabled.
Use Select Data dialog to add a new series.
Select the new series, which should already be on the secondary axis, and change it's chart type to xy-scatter.
Go back to select data dialog and select x and y ranges.
You will now see Dummy series axis choice is primary and disabled.
Chart Question 4.xlsx
Thank you that helps a lot. I was able to mostly replicate in a new sheet. I have two small issues. I am not sure what I did wrong. 1) My error bars are moving together when I am adjusting factors, instead of separately. 2) In my Gain error bar there is a little bar in the star, and not sure how to get rid of it. See attadched.
Thanks
I figured out both. It's because the legend entry P&L loss was missing. I deleted it on bar graph, because it was populating a bar next to P&L gain. How do I eliminate the extra bar?
I see. You changed to primary, then set it to overlap? That slightly distorts the Red color. I guess there is no way to put it back to regular red?
Chart Question 4.xlsx
sorry for all the replies. See attached. I believe I have fully replicated your original sheet. The only issue I am seeing, and not sure how to resolve, is that when I change the number in error bar, and I hit save, all the data labels under the bar chart move. Is there a way to fix that? Also, not sure on that color issue when you do an overlap.
I have change position of xy-scatter series data point to be left side of bracket. The error bar value for Plus is read from cell whilst negative is static at ={0}. Hopefully now the positioning will be easier to understand as it is not trying to center the data point.
You can remove the data marker from the series by setting it to none.
You can format the series used for losses to be any shade of red you want by formatting the fill colour.
I don't see any problems with label alignment.
Andy-
What do you mean when you say you changed position of xy-scatter series data point to be left side of bracket. How do you do that? Also, when adjusting the error bars, I may have been doing it wrong, by adjusting the x-axis which shifted secondary axis.
Previous the single data point was in the middle of the span with error bars going minus (left) and plus(right).
To make it easier I changed the X value of the data point to the Left side and the error bar is now only a plus(right) for the complete span distance. There is still a minus error bar but the value is zero. The minus is needed to give the little cap on the left side of the span.
The only changes needed where to the x value and error bar value on the sheet. The error bars reference for the minus part needs to be changed to ={0} rather than use a cell reference. This is done via the format dialog for the error bar using the Set Custom button.
In theory you should not need to alter the secondary horizontal axis information.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks