The most important elements of a Microsoft Excel chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more; Modifying an Excel Graph visually: styles and colors, create a pictograph, shapes, effects, text etc. Basic Excel Charts like Column charts, Bar charts, Pie charts, Line charts. Click the Text Fill button and select Green. Click the Text Outline button. Point to Weight and click the 2-1/4 line. Click the Text Effects button.
To add a text box in Excel 2013 like the one shown to the chart when a chart is selected, select the Format tab under the Chart Tools contextual tab. Then, click the Insert Shapes drop-down button to open its palette where you select the Text Box button.
To insert a text box in a worksheet when a chart or some other type of graphic isn’t selected, you can open the Insert tab on the Ribbon and then click the Text Box option on the Text button’s drop-down palette.
Excel then changes the mouse pointer or Touch Pointer to a narrow vertical line with a short cross near the bottom. Click the location where you want to draw the text box and then draw the box by dragging its outline. When you release the mouse button or remove your finger or stylus after dragging this pointer, Excel draws a text box in the shape and size of the outline.
After creating a horizontal text box, the program positions the insertion point at the top left, and you can then type the text you want to appear within it. The text you type appears in the text box and will wrap to a new line should you reach the right edge of the text box.
You can press Enter when you want to force text to appear on a new line. When you finish entering the message for your text box, click anywhere outside the box to deselect it.
After adding a text box to a chart or worksheet while it’s still selected, you can edit it as follows:
Active2 years, 3 months ago
Is there a way to edit the weight of all lines at once on an Excel line chart?
Outline In Excel
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights individually, and it's hard to see the data if the lines were thinner, it'd be a bit easier). I can't see a way to multi-select them, which seems a bit awful.
Edit: I eventually got it working with the following code (after learning a bit of VB). I doesn't seem to help readability of the graph much though! Chris helped me sort it out, so I'll give him the tick.
Chris Dennett
Chris DennettChris Dennett
27211 gold badge22 silver badges1010 bronze badges
7 AnswersText 1 For Chart Outline In Excel Machinery
Probably easiest to write a quick macro, somthing like
chris neilsenchris neilsen
This is a more copy-and-paste compatible version of Chris's answer:
Text 1 For Chart Outline In Excel Macro
Just select the chart and run the macro.
32bits32bits
Text 1 For Chart Outline In Excel Macro
Enhancement: create a VB variable (LineWT) that points to a cell in the spreadsheet. Then instead of 'Format.Line.Weight = 0.25' change 0.25 to LineWT. Then you can change the line weight by changing it on spreadsheet and clicking the macro button.You can use similar code to set X/Y Axes names with pointers to the spreadsheet.
BillBill
This worked perfectly for me. I used this code to have it edit all lines in all charts on all sheets of a workbook
David MarkmanDavid Markman
I don't think you can multi-select lines. The simplest way is probably to change one and then to select each on in turn use Ctrl-Y to go through and re-do the line weight change.
Rhys GibsonRhys Gibson
3,91822 gold badges3333 silver badges4545 bronze badges
This code changes the line width of all charts in the active spreadsheet including chart sheets:
(Adapted from David Markman's answer.)
ChaimGChaimG
In the Home tab, Font section, select the Borders drop-down. Pick your required line style or color. A pencil will appear. Instead of using the pencil to click on each line you want to change, go to the corner of the grid of cells you want to change, and hold down the CNTRL key. Drag the pencil over the required grid of cells, and all will change to the style or color you have selected.
D LoffellD Loffell
Not the answer you're looking for? Browse other questions tagged microsoft-excelformattingmicrosoft-excel-2010charts or ask your own question.Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |