We help IT Professionals succeed at work.

Last data point in Excel chart not showing up

mssantan
mssantan asked
on
there are numerous charts in this excel file that are working fine.   The one labeled "Fortis EBITDA" its on the top right... does not show the last data point for DECember.   Please help, cant figure it out.
CIM.xlsx
Comment
Watch Question

Try starting the series from column C instead of column B.

Author

Commented:
Can you walk me thru?  Where do I make the change?
SimonPrincipal Analyst

Commented:
Edit the horizontal (category axis) of the graph. Switch from text to numbers and set auto minimum and auto maximum and then switch back to text.
Rob HensonFinance Analyst

Commented:
Right click on the chart and choose Select Data. Change the graph data range to:

='Fortis Graphs'!$A$2:$BJ$4

Click OK and then repeat, right click, Select Data.

Deselect the Sales series and click OK.

Only EBITDA will show, with Dec14 bar included.

Thanks
Rob H
Easiest way to modify the series is to select that series and modify the formula in the formula bar. You would change this...

    =SERIES('Fortis Graphs'!$A$4,'Fortis Graphs'!$B$2:$BJ$2,'Fortis Graphs'!$B$4:$BJ$4,1)

....to this....

    =SERIES('Fortis Graphs'!$A$4,'Fortis Graphs'!$C$2:$BJ$2,'Fortis Graphs'!$C$4:$BJ$4,1)

Once modified, hit Enter to apply.

Wayne

Author

Commented:
Rob H... after doing that... the data point for dec shows... but it throws off the quarterly calculation.  and also doesn't show DEC lableCan someone edit the file and send back correct and I can look at properties to see what you did.   thx

Author

Commented:
Wayne... I tried yours... it does add the data point.. but changes the legend from starting with March, to starting with Jan... we want it to end on each quarter..  which therefore it doesn't end with Dec 14
How do your quarters end, if not Mar, Jun, Sep, and Dec?
Principal Analyst
Commented:
>Can someone edit the file and send back correct
CIM.xlsx
This is with the minimal correction of setting auto min and max on the category axis. No changes to data series... It now displays the "Dec" label and data.
Martin Liss"There is still no cure for the common birthday." ~John Glenn
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.