Bar Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 15 Jan 2007 21:22 GMT

I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Epinn - 15 Jan 2007 21:52 GMT

Not attempting to solve your problem. But just want to share with you an excellent site (tutorial via video) which I have benefited from a great deal.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down to "All about charts." It may not give you exactly what you want but may inspire you? I think a bar and line was discussed.

I may want to experiment your request when I have more time later. Let's see what the experts say.

Epinn

I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Epinn - 15 Jan 2007 22:17 GMT

Did your boss see that in a presentation? Wonder if it is done in PowerPoint.

Have you cross-posted to microsoft.public.excel.charting or PowerPoint?
If not, don't do it now until you have waited for a while; something to do with netiquette. Just a thought.

Not attempting to solve your problem. But just want to share with you an excellent site (tutorial via video) which I have benefited from a great deal.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down to "All about charts." It may not give you exactly what you want but may inspire you? I think a bar and line was discussed.

I may want to experiment your request when I have more time later. Let's see what the experts say.

Epinn

"Craig" <craigjose@hotmail.com> wrote in message news:e25X1sOOHHA.4644@TK2MSFTNGP03.phx.gbl...
I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Epinn - 16 Jan 2007 09:23 GMT

Worth checking.

http://www.andypope.info/charts/brokencolumn.htm

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Did your boss see that in a presentation? Wonder if it is done in PowerPoint.

Have you cross-posted to microsoft.public.excel.charting or PowerPoint?
If not, don't do it now until you have waited for a while; something to do with netiquette. Just a thought.

Epinn

"Epinn" <someone@example.com.NO_SPAM> wrote in message news:eAR#3HPOHHA.3916@TK2MSFTNGP02.phx.gbl...
Not attempting to solve your problem. But just want to share with you an excellent site (tutorial via video) which I have benefited from a great deal.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down to "All about charts." It may not give you exactly what you want but may inspire you? I think a bar and line was discussed.

I may want to experiment your request when I have more time later. Let's see what the experts say.

Epinn

"Craig" <craigjose@hotmail.com> wrote in message news:e25X1sOOHHA.4644@TK2MSFTNGP03.phx.gbl...
I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Craig - 16 Jan 2007 15:24 GMT

Epinn-

Thanks for the links.

Worth checking.

http://www.andypope.info/charts/brokencolumn.htm

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Epinn

"Epinn" <someone@example.com.NO_SPAM> wrote in message
news:e6UgFMPOHHA.4992@TK2MSFTNGP04.phx.gbl...
Did your boss see that in a presentation? Wonder if it is done in
PowerPoint.

Have you cross-posted to microsoft.public.excel.charting or PowerPoint?
If not, don't do it now until you have waited for a while; something to do
with netiquette. Just a thought.

Epinn

"Epinn" <someone@example.com.NO_SPAM> wrote in message
news:eAR#3HPOHHA.3916@TK2MSFTNGP02.phx.gbl...
Not attempting to solve your problem. But just want to share with you an
excellent site (tutorial via video) which I have benefited from a great
deal.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down to "All about charts." It may not give you exactly what you
want but may inspire you? I think a bar and line was discussed.

I may want to experiment your request when I have more time later. Let's
see what the experts say.

Epinn

I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Epinn - 16 Jan 2007 15:57 GMT

You are welcome! I have a feeling you meant to say *column* chart.

Hope the links on broken columns help.

Epinn

Epinn-

Thanks for the links.

Worth checking.

http://www.andypope.info/charts/brokencolumn.htm

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Epinn

Did your boss see that in a presentation? Wonder if it is done in
PowerPoint.

Have you cross-posted to microsoft.public.excel.charting or PowerPoint?
If not, don't do it now until you have waited for a while; something to do
with netiquette. Just a thought.

Epinn

Not attempting to solve your problem. But just want to share with you an
excellent site (tutorial via video) which I have benefited from a great
deal.

http://www.datapigtechnologies.com/ExcelMain.htm

Scroll down to "All about charts." It may not give you exactly what you
want but may inspire you? I think a bar and line was discussed.

I may want to experiment your request when I have more time later. Let's
see what the experts say.

Epinn

"Craig" <craigjose@hotmail.com> wrote in message
news:e25X1sOOHHA.4644@TK2MSFTNGP03.phx.gbl...
I need some help. I have a bar graph that has values ranging from 98% to
4%. My boss would like me to show the garph maximum value at 10%. He want
to show all bar but at the ones above the 10% he would like to show a break
in the bar and then show the % at the top. He says he has seen it before
and it looks like the bar was pulled apart and it show the bottome portion
up to 10% and then a small portion above the 10% line. He says the edges at
the top looks like a riped piece of paper.

Does anyone know how to do this in done?

Reply to this Message

Rate this thread: