| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Autoshapes in Bar Graphs
Andy, you are AWESOME!
This is working great. "Andy Pope" wrote: See Jon's pages on floating columns and possible waterfall charts. http://peltiertech.com/Excel/Charts/...ngColumns.html Cheers Andy Mitzi wrote: Del, thanks that was easy. One more question if I may. My graph has three columns. the first column begins at 97 million, the second drops down to 80 million, the third up to 87 million. My goal is to have the first go from 0-97 million, then the second to show the drop from 97 to 80 m, but I want the arrows to be relative to the scale and float from left to right, instead of above/below axis. Does this make sense? "Del Cotter" wrote: On Fri, 2 Feb 2007, in microsoft.public.excel.charting, Mitzi said: Can I change a bar graph to have an arrow at the top or bottom? Yes you can. Use the Autoshapes menu in the Drawing toolbar, and select an arrow form you like the look of. When you've created it, Cut (or Copy) it, select a bar, and Paste the arrow. The bar will now be an arrow shape instead of a rectangle. Repeat with the other bar series until done. Change the border and fill colours to suit before you paste the arrow, because you won't be able to do it afterward. If you try, you'll only surround the arrow with a rectangular coloured border, and hide the arrow with a rectangular fill colour. Postscript: hey, I didn't expect that to happen! I just experimented with copying and pasting the arrow back out of the bar and on to the plot area again, which worked, but when I tried to change the arrow's fill colour it didn't work. But neither did the fill colour cover the arrow, as it did when it was part of the bar. Instead it filled *under* the arrow, making a neat rectangular background! That's an unexpected result. The multicoloured shape now pastes back into the bar. Repeating the process produces a narrow border of a third fill colour around the rectangle, but that seems to be the limit of recursion: further cutting and pasting produces no more nested levels of fill colour. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel graphs won't update | Charts and Charting in Excel | |||
| Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
| HYPERLINK GRAPHS | Charts and Charting in Excel | |||
| Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
| Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions | |||
Threaded Mode
