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...
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...
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...
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...
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...
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...
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...
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 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.