Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello,
Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
With the chart selected you can use the Insert tab Illustrations Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Robert11" wrote in message ... Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Thank you very much for the help. One more on this, please. Apparently the default grid does not allow me to make a truly horiz line. Moving the end of the line always seems to result in just a bit more than horiz if I move it up or down just a little. Hard to believe the grid doesn't allow for a true horiz line, but that seems to be the case. Think I'm doing anything wrong ? How can I change the grid spacing ? Is it possible to do a "nudge" of one end of the line ? How ? Thanks again, appreciate the help, Bob ------------------ "Andy Pope" wrote in message ... Hi, With the chart selected you can use the Insert tab Illustrations Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Robert11" wrote in message ... Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob |
#4
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Robert11,
Hold the Shift key down when you add a line, that will result in a horizontal (or vertical) line. Ed Ferrero www.edferrero.com |
#5
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Ed,
Nope, doesn't do it. Line still not absolutely horiz. What am I possibly doing wrong ? Also, how does one call up the default grid (spacing) and change it perhaps ? Is there a "nudge" function somewhere ? Should have stayed with my 2003 Excel, I guess. That vers was so simple and intuitive ! Thanks again for help; appreciate it, Bob ---------------- "Ed Ferrero" wrote in message ... Hi Robert11, Hold the Shift key down when you add a line, that will result in a horizontal (or vertical) line. Ed Ferrero www.edferrero.com |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Finally got it. Thanks for all the help. Bob ---------------------------- "Robert11" wrote in message ... Hi Ed, Nope, doesn't do it. Line still not absolutely horiz. What am I possibly doing wrong ? Also, how does one call up the default grid (spacing) and change it perhaps ? Is there a "nudge" function somewhere ? Should have stayed with my 2003 Excel, I guess. That vers was so simple and intuitive ! Thanks again for help; appreciate it, Bob ---------------- "Ed Ferrero" wrote in message ... Hi Robert11, Hold the Shift key down when you add a line, that will result in a horizontal (or vertical) line. Ed Ferrero www.edferrero.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
Adding Horizontal Lines to a stock chart | Charts and Charting in Excel | |||
Help on adding the second trendline in a "lines on 2 axes" Chart via VBA | Charts and Charting in Excel | |||
adding dynamic lines or quadrants to bubble chart? | Charts and Charting in Excel | |||
Adding lines of data to an area chart | Excel Discussion (Misc queries) |