Color Reports & Hatch Styles

Posted on 2004-10-18
Last Modified: 2006-11-17
Does anyone know if it is possible to create color charts that also contain hatched styles?

I only see an option for "Color or Black and White".

If anyone knows how to accomplish both, please let me know.

Or, if you know that it cannot be done, please let me know that also.

Question by:jrandallsexton
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
LVL 10

Expert Comment

ID: 12340103
There is a chart color format expert.

1. Insert your chart
2. Right click on it
3. Select chart expert
4. Select options tab
5. In chart color, click fomat button
You can make your own colors or pick normal coors from here


Author Comment

ID: 12340136
Your response tells me that I did not make my question clear.

I need color AND hatch style.  I've already seen what you told me.

All that allows me to do is select colors based on the value of the fields.

I need the chart to be in color as well as have hatch styles.
LVL 10

Expert Comment

ID: 12340158
do you mean you want format the background color or border color. You can do those too. What do you really want to see in color.
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Author Comment

ID: 12340189
Let's take a bar chart for example.

My bars are already in diferent colors.  That is fine.

I need to add hatch styles for each of those different colors.

Where are you getting border color from?

Do you know what a hatch style is?  It is the pattern of lines that are used for black and white reports.

I need a report that shows in color, but also provides hatch styles that way when it is printed on a black and white printer, you can still differentiate between series.
LVL 28

Accepted Solution

bdreed35 earned 300 total points
ID: 12340207
You can change the pattern (hatch) colors if you choose.

Once you have your chart created, in preview mode, right click the part of the chart you want to change, and choose Chart Options, Selected Item.
Click the Pattern button in the dialog, anc then chosse the Pattern, and then the Background and Foreground colors using the corresponding buttons.
LVL 10

Expert Comment

ID: 12340233
right click the chart
click format chart
click border tab
border color can be chnaged from the drop down
if you click the background checkbox then you can choose the colors


Author Comment

ID: 12340235

Yes!  That is exactly what I was looking for.

Now, I don't want to have to set this manually for each series because it's going to be a varying number of results in production (reports are populated via datasets in VB.Net)

Is there a way to tell Crystal to use colors and hatch styles automatically?

Author Comment

ID: 12340255

I realize you are trying to help, but you obviously have no idea what I'm talking about.  

I was never talking about the border.
LVL 28

Expert Comment

ID: 12340398
Unfortunately, I don't know of a global setting for the pattern.

The best that I know of is to run the report so that you get around the maximum number of series and then change each series while in Preview.  Design only shows like 3 series so it doesn't really help to do it there.
You can have the changes made to all charts (if your chart resides in a grouping) by right clicking it and choosing "Apply changes to all charts".

So, the short answer is that it is a manual effort.

Author Comment

ID: 12340416
I was afraid you were going to say that.

Thanks again.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question