Color shade line chart by quarter

dpm1028
dpm1028 used Ask the Experts™
on
Hi,
I have a line chart that I use to show sales information.  I use it all year, but would like to highlight (via background shading) each quarter of the year.  I have had no luck so far.  Any suggestions?
Dan
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Let me make sure I understand the problem.

You have a report with a line chart showing sales over a period of time.  You want to visibly differentiate between the quarters in some way.

I am not sure that is possible.

What version of Crystal do you have?

mlmcc

Author

Commented:
You are correct.  I have a line chart (3 lines) that I update regularly, I would like to add some color to the graph (background) that is one color from 1/1/16 to 3/31/17 then 4/1/17 to 6/30/17 etc..
I am on Crystal Reports 2008
Dan

Commented:
Hi,

Is the report data for a particular year or for multiple years?
Assuming the data for a year, if the quarter details are being calculated at report level, then the same information can be used to provide different color for different quarter under "Color Highlight" tab under chart expert.
If it's not done, then we can create a formula for quarter using something like this:

if month({date field}) in [1,2,3] then 1
else if month({date field}) in [4,5,6] then 2
else if month({date field}) in [7,8,9] then 3
else 4
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Author

Commented:
I embedded a picture of a graph today.  I also embedded the Color Highlight change I tried.  Nothing changed on the graph.
This is only for one year at a time.
If I understand your instructions, the Color Highlight tab will allow me to change one of the items on my graph.  


CRGraph.bmpColor-Highlight.bmp
Commented:
Hi,
Unfortunately yes, the color for line chart can't be changed at an interval though we can change the markers for the series as in attached samples.
Capture.JPG

Author

Commented:
Thank you all for responding

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial