[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

Color Reports & Hatch Styles

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.

Thanks.
0
jrandallsexton
Asked:
jrandallsexton
  • 5
  • 3
  • 2
1 Solution
 
ebolekCommented:
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

Regards
Emre
0
 
jrandallsextonAuthor Commented:
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.
0
 
ebolekCommented:
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.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
jrandallsextonAuthor Commented:
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.
0
 
bdreed35Commented:
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.
0
 
ebolekCommented:
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

Regarsd
Emre
0
 
jrandallsextonAuthor Commented:
bdreed35:

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?
0
 
jrandallsextonAuthor Commented:
Emre:

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.
0
 
bdreed35Commented:
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.
0
 
jrandallsextonAuthor Commented:
I was afraid you were going to say that.

Thanks again.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now