Is there a work around for plotting negative and positive growth values in excel in a logarithmic scale format, while preserving the original data values?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
I am plotting EBITDA growth over 2 different periods as a bar graph. In some cases, the growth in one period will be negative, and in others it is positive. One bar goes up off the x-axis, and one bar will go down, which is exactly what I want. However, what I want to highlight is the relative difference in the EBITDA over the two periods. I.e. if EBITDA goes from 100 to 75, the growth is -25%. If EBITDA then goes back to 100, the growth is 33%. I want the graph to display -25% and + 33% as the same sized bars. The way it graphs now, growth looks to be 50% larger than the decline, but reality is that it is exactly the same.
Excel will not display logarithmic scales with negative values properly.
I can take the logarithmic growth of the data, which will produce the right sized bars when plotted. However, I lose the ability to show the data values, and scales in the original values. I.e. the LN() of the growth values in the scenario described above would be -29% and +29%. The bars are now equal size, but neither the data labels, nor the scale would be the actual values, which is what I want to show.
Anyone have any thoughts, ideas, or suggestions for a possible work around that do not involve manually changing the values in the data labels or the scale? This file will be used as a template for many future analyses, and I am trying to automate as much as possible.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I am plotting EBITDA growth over 2 different periods as a bar graph. In some cases, the growth in one period will be negative, and in others it is positive. One bar goes up off the x-axis, and one bar will go down, which is exactly what I want. However, what I want to highlight is the relative difference in the EBITDA over the two periods. I.e. if EBITDA goes from 100 to 75, the growth is -25%. If EBITDA then goes back to 100, the growth is 33%. I want the graph to display -25% and + 33% as the same sized bars. The way it graphs now, growth looks to be 50% larger than the decline, but reality is that it is exactly the same.
Excel will not display logarithmic scales with negative values properly.
I can take the logarithmic growth of the data, which will produce the right sized bars when plotted. However, I lose the ability to show the data values, and scales in the original values. I.e. the LN() of the growth values in the scenario described above would be -29% and +29%. The bars are now equal size, but neither the data labels, nor the scale would be the actual values, which is what I want to show.
Anyone have any thoughts, ideas, or suggestions for a possible work around that do not involve manually changing the values in the data labels or the scale? This file will be used as a template for many future analyses, and I am trying to automate as much as possible.
