I'm having trouble on the attached graph where I'm trying to track a company Cash Balance on one axis, and on the secondary axis track both Operating Expenses (a positive number) and Cash Burn (a negative number)
For some reason, the Cash Burn on the attached isn't cooperating and actually plotting correctly. Any pointers are appreciated. Thanks.
What is incorrect about the "cash burn" series? What type of line chart did you intend? Checking the chart type of the line chart series, they are both set to "stacked line", and they look correct for a stacked line chart. Perhaps you intended to plot them as regular line chart and not stacked line?
Originally Posted by shg
The line is straight and the numbers do not plot correctly to either the primary or the secondary axes
It looks correct as a stacked line. With a stacked line, the first series (operating expense) is plotted, then the second series (cash burn) is plotted relative to the first series. So the first point for OE is 240, so it goes up 240 units along the secondary axis. Cash burn is then 250 units down from there to end up about -10. The last point OE goes up to 760, then the cash burn goes down from there 800 to end up at -40. For a stacked line chart, it looks correct to me. Did you intend it to be a regular line chart?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks