Changing font style/size/color/etc for multiple series in a chart?

Programming and Web Development Forums - MS EXCEL - Microsoft Office Excel

Skip to content

Changing font style/size/color/etc for multiple series in a chart?

MS EXCEL
Post a reply

    Next

  • 1. how to create a chart from the source which does not have explicit numbers
    Hi, I am not very good wit microsoft excel...so any help is greatly appreciated. I need to create a chart with below mentioned data in two columns. The chart should show the number of gaps in each bundle. (i.e Yellow -2, Red - 4 and Orange - 1). Since the data is in the below format, how can I calculate the number of gaps in each bundle and make a chart out of it? Gap ID Bundle gap_01 Yellow Red gap_02 Orange Red gap_03 Red gap_04 Red Yellow gap_05 Yellow gap_06 Red gap_07 Red Waiting for your reply. Thanks in advance! Prasanna
  • 2. Histogram in Excel
    I have written a macro that uses the data-analysis tool to creat a histogram. It turns out too small and I have to manually enlarge it. I can't seem to do it in the macro, because one has to select thee chart and I can't figure out how to do this since it reuires a chart number to select it. And of course the number changes every time the macro is run. So my question is: In a VBA macro how do I select the only chart when I will not know it's number. Help will be appreciated. Thank you.
  • 3. Need help formatting chart
    I am trying to make a chart to show the accuracy of food choices made my significantly disabled student. The worksheet I made has food choice names, the data collection dates, and then notations of whether the student ate all (a) some (s) or none (n) of the food after choosing. How do I get a chart that will show the a,s and n values as different colors in a stacked bar? (at least that's what I think I am looking for, but would be happy with any clearly readable chart)
  • 4. How do I set different chart colors as default in Excel
    Default area background is a dull gray, I prefer white. I do I set this as standard

Changing font style/size/color/etc for multiple series in a chart?

Postby SG9zc2RhZGR5 » Thu, 02 Jul 2009 11:00:01 GMT 

I have a stacked bar chart (but note applies to all charts) that I have added 
data labels to in Excel 2007.  However, the data labels are the wrong font 
size and color.  

When I go to format data labels in the "Labels" section of the Chart 
Tools/Layout ribbon, there is no apparent option to change font.  I can right 
click on a single series and change it, but doing that for every series in a 
complex chart seems ludicrous.

Is there any way to change the font for multiple series in one step?  
The same holds true for changing the number format or any other 
characteristic for multiple series at once (the format data labels still only 
applies to one series or label at a time - very painful).

Thanks for any help!
Top

Re: Changing font style/size/color/etc for multiple series in a chart?

Postby Peter T » Thu, 02 Jul 2009 18:25:41 GMT 

To reformat datalabels in all series in one go you'll need a macro, adapt 
the following to your needs (revert back if not sure how)

Sub DataLabelFont()
Dim cht As Chart
Dim sr As Series
Dim dls As DataLabels

    On Error Resume Next
    Set cht = ActiveChart
    If cht Is Nothing Then
        MsgBox "No chart is selected"
        Exit Sub
    Else
        If MsgBox("reformat datalabels..." & vbCr & "*no undo*" _
                  , vbOKCancel) <> vbOK Then
            Exit Sub
        End If
    End If
    On Error GoTo 0
    For Each sr In cht.SeriesCollection
        On Error Resume Next
        Set dls = sr.DataLabels
        On Error GoTo 0
        If Not dls Is Nothing Then
            dls.NumberFormat = "#,##0.000"
            With dls.Font
                .Bold = False
                .Italic = False
                .Size = 8
                .Color = RGB(25, 25, 128)
            End With
        End If
    Next

End Sub

Regards,
Peter T
Top

Similar Threads:

1.Changing font style/size/color/etc for multiple series in a ch 

Thanks, Peter, but I must confess I was hoping for a simpler solution that I 
was just overlooking, as I am not a macro-master.  I'll keep this in my back 
pocket to try for a really complicated one, but for now, I may have to 
maintain the brute force approach.  Thanks for taking the time to reply.  I 
really appreciate it.

"Peter T" wrote:

> To reformat datalabels in all series in one go you'll need a macro, adapt 
> the following to your needs (revert back if not sure how)
> 
> Sub DataLabelFont()
> Dim cht As Chart
> Dim sr As Series
> Dim dls As DataLabels
> 
>     On Error Resume Next
>     Set cht = ActiveChart
>     If cht Is Nothing Then
>         MsgBox "No chart is selected"
>         Exit Sub
>     Else
>         If MsgBox("reformat datalabels..." & vbCr & "*no undo*" _
>                   , vbOKCancel) <> vbOK Then
>             Exit Sub
>         End If
>     End If
>     On Error GoTo 0
>     For Each sr In cht.SeriesCollection
>         On Error Resume Next
>         Set dls = sr.DataLabels
>         On Error GoTo 0
>         If Not dls Is Nothing Then
>             dls.NumberFormat = "#,##0.000"
>             With dls.Font
>                 .Bold = False
>                 .Italic = False
>                 .Size = 8
>                 .Color = RGB(25, 25, 128)
>             End With
>         End If
>     Next
> 
> End Sub
> 
> Regards,
> Peter T
> 
> "Hossdaddy" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> >I have a stacked bar chart (but note applies to all charts) that I have 
> >added
> > data labels to in Excel 2007.  However, the data labels are the wrong font
> > size and color.
> >
> > When I go to format data labels in the "Labels" section of the Chart
> > Tools/Layout ribbon, there is no apparent option to change font.  I can 
> > right
> > click on a single series and change it, but doing that for every series in 
> > a
> > complex chart seems ludicrous.
> >
> > Is there any way to change the font for multiple series in one step?
> > The same holds true for changing the number format or any other
> > characteristic for multiple series at once (the format data labels still 
> > only
> > applies to one series or label at a time - very painful).
> >
> > Thanks for any help!
> > 
> 
> 
>

2.How do I view toolbar with font color, font size, etc in Adobe 8 

Using Adobe Acrobat 8 - I was inserting text boxes into a document, at one 
time there was a toolbar showing that let me select the font size, style etc. 
for the text in the text box.  Went back later to fix text and toolbar was 
gone, how do I get this toolbar back?

3.Change Font Size on Multiple Charts at the same time 

Hi,

I have about 60 charts in a workbook and would like to change all of the 
font sizes - title, axis, labels to a different font size. Is there a way to 
do this with a macro? I also have some text boxes placed on the charts and 
would like to change them as well. 

Thanks!

4.Is there a font that contain the Excel chart series marker styles 

I'm have a need to create a legend to show the points outside the Excel 
charting environment.  Does anyone know of a font that includes most of 
Excel's chart series marker style?

Thanks,
- Pat

5.Changing Font color based on font type or size 

My wife has a large book collection the she keep track of in Excel. She wants 
to have the colors of titles of book different from title of series and or 
author. Is there a easy way to do this other than changing the font color 
every time. The color she wants is not in the standard color pallet. Any info 
would help

6. Changing the font size in Styles...

7. Changing font size and style

8. Changing font sizes in drop down lists,etc

Post a reply

Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 61 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group