Spikenaylor
Board Regular
- Joined
- Apr 14, 2013
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
Hi
I have my pivots all working fine, the charts work fine,
I have my values showing as bars and my [FONT=inherit !important][FONT=inherit !important]limit [/FONT][FONT=inherit !important]values[/FONT][/FONT] showing as a line, this all works fine until, I only display one value upon which the limit value disappears, if i change it to a bar, it always shows, really annoying, as I wish to permanently show my limit line. Anyone one got any methods to incorporate a line acting as a limit indicator on a pivotchart, Why can't [FONT=inherit !important][FONT=inherit !important]microsoft[/FONT][/FONT] have incuded a simple control for this requirement.
Any help greatly appreciated.
Mike
I have my pivots all working fine, the charts work fine,
I have my values showing as bars and my [FONT=inherit !important][FONT=inherit !important]limit [/FONT][FONT=inherit !important]values[/FONT][/FONT] showing as a line, this all works fine until, I only display one value upon which the limit value disappears, if i change it to a bar, it always shows, really annoying, as I wish to permanently show my limit line. Anyone one got any methods to incorporate a line acting as a limit indicator on a pivotchart, Why can't [FONT=inherit !important][FONT=inherit !important]microsoft[/FONT][/FONT] have incuded a simple control for this requirement.
Any help greatly appreciated.
Mike
