chart axis labels

  1. M

    Run time error 1004 with vba ticklabels.offset

    Hello, I'm trying to use VBA to alter the parameters of my chart. But specifically with the Ticklabels.Offset - I get "Run time error 1004 - Parameter not valid", and I can't work out why. The code below works for the maximum scale and minimum scale, then gets an error where labelled...
  2. T

    Changing font in axis label using VBA removes content

    I have many graphs in a spreadsheet that I use a macro to apply uniform formatting to them. I use this snippet of code ' set y-axis label .Axes(xlValue).AxisTitle.Select With Selection.Format.TextFrame2.TextRange.Font .Size = 10 End With within the follow script to change...
  3. F

    Is there any way to exceed the maximum # of data series per chart?

    I'm tracking the daily productivity for over 300 employees and 250 working days. Currently, the date/working day is the Legend Entry (Series) and the employee name is the Horizontal (Category) Axis Label. I need a way to switch them around so that the date/working day will be the Horizontal...
  4. W

    Custom excel chart

    Hi I have a stacked bar chart in excel. This is made up of positive and negative comments. I can get the negative topic names down one side of the axis but can't work out how to get the positive down the right hand side of the chart? (Example below) X axis...
  5. A

    Group data by week with date format axis

    I have data which I want to display on an Excel column chart. It represents the number of sales per week, where the date is the first day of the week: If I leave the dates as dates then Excel interprets this as data for one day out of seven, so I get thin columns with large gaps...
  6. G

    Add Column to Bar chart as Labels

    Hi all, I am having trouble with a simple bar chart... Its for keywords and has three columns:- keyword, average monthly visits, competition. The graph shows the keyword on the left (horizontal category axis labels) and then a horizontal bar chart showing the average monthly visits (numerical...
  7. O

    Pivot Chart Confusing Primary and Secondary Axes - VBA

    I'm having a bit of difficulty getting Excel to play nice. Simply put, i've got a Pivot Chart that doesn't know which its xlValue axes are. I have a piece of VBA to format the chart that sporadically works and then gets confused again. I've tried everything I can think of to get this working...
  8. Z

    Chart Category (Horizontal) Axis Labels Stuck As Numbers

    Okay, so I have a bar chart I've created whose data source is a range of cells (Progress!$L$4:$Q$6). The category labels (horizontal axis) of the chart USED to reflect the category names as text values (nameA, nameB, nameC, nameD, and nameE), which is what they were supposed to do. I should...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top