1. M

    Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells

    I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...
  2. F

    How do I make the color gradient of my surface chart to match my "heat map"?

    Here is my surface chart and the colors clearly does not match those in my heat map How can I fix this?
  3. masud8956

    Problem refreshing charts in multiple sheets depended on data from specific sheets

    Hi, I have some data involving dates {including =TODAY()} and numbers in Sheet1 and 2. Sheet 2 is hidden from view. in Sheets 3, 4 and 5, I have several charts (Line, Doughnut and bar chart). The line chart is located at Sheet3 getting data from Sheet2 only (hidden sheet). Doughnut chart is...
  4. J

    Edit chart category axis data items visible in VBA

    HI all, I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each...
  5. M

    Chart based on table not updating as expected (VBA)

    Hi I've written a macro which updates a clustered column chart in Sheet 1 that's based on data in a table in Sheet 2. However, the chart is not fully updating. The ‘source data’ for the chart is =Table5[#All] (based on a table that currently exists in Sheet2). The table in Sheet 2 is...
  6. S

    Loop issue to export picture

    Hi all, I want to export a group of shapes as an image. The group consists of various shapes that are displayed / hidden based on user selection and show incident types on a map. All I want is to export this map to a JPG. I have crafted a script from various finds online, it works sometimes...
  7. W

    Prevent a dynamic line chart from interpreting formula output of "" as 0?

    I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart. The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell...
  8. M

    Delete chart from a specific cell using VBA

    Hi I've used the code below to move a chart from one sheet to another (from Sheet 5 to cell M2 in Sheet 1). However, when re-running the code to create the chart, I would like to delete the existing chart in cell M2 of Sheet 1, without deleting the other charts in Sheet 1. Does anyone know...
  9. M

    Range plus chart

    Hi I'd like to do 3 simple things with VBA, which I haven't done before. i) I'd like to select a range, but ignore the last row, when selected. So if I had the values a, b, and c in cells A1, A2, and A3, and the values 1, 2, 3, and 4 in cells B1, B2, B3 and B4, I'd like to select the range...
  10. N

    No data labels on Pareto Line of Pareto Chart

    Excel in office 365 now has a dedicated Pareto chart which is quick and easy to use. However, there is no option to add data labels to the Pareto line to show the percentage values. Am I missing something obvious here?
  11. D

    Looking to improve efficiency of code

    The following code was taken from a macro I have been working on .... most of which is due to the help of people within this Forum... so thank you. Unfortunately, it takes over 60 seconds to run. I can't blame those who helped me in the past because I never conveyed the entire scope of the...
  12. M

    Chart Help

    Hello, I'm using excel 2016. Every time I try to do a bar chart, it comes up as thin lines going up and down. Modifying doesn't seem to help. Where are the bars? How can I get the lines to go away and show me the thick bars that I want? Thanks in advance.
  13. A

    Excel chart series gap

    Hi Folks, I have four column chart and the gap between series is big. I used the gap width button and the column width is increased overlap adjustment does nothing. Is there a way to bring the columns closer to each other? Thanking you, AFD
  14. D

    Missing Chart Data Labels

    Hello, I have a table with some data on the y axis and months on the x axis. It looks something like this (I am unable to publicly share the actual chart or data): <tbody> A B C D E F G H I J K L M 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Plan 10 15 20 20 20 15...
  15. G

    Week to date ( Sunday to Saturday)

    Hi, I need to create a dynamic bar chart that shows data from Sunday to Saturday for current week. If column A contains dates, column B contains values to be displayed in bar chart. I want the bar chart to always start from the most recent Sunday and chart each day of the week until Saturday...
  16. P

    Organisation Chart in Excel

    Hi, I have been given a task to create an organisation chart for over 2,000 employees in Excel because it can then be presented in a specific format (effectively I am using grouping to expand and collapse rows to show how the hierarchy flows). This is extremely time consuming and inefficient...
  17. D

    Bar Chart - Gap Between Bars

    I have created a very simple bar chart. The gap between bars is too wide and I want to reduce it. I am aware about using Format Data Series - Gap Width to reduce gap. However it also reduces the width of bars. Is there any option to reduce the gap between bars without altering their...
  18. B

    Change reference columns of a chart

    Hi all. I have a spreadsheet with 90+ charts on, and need to change the cell references by 2 columns (i.e. from column G to column E). Is there a quick way to do this without having to go in to each chart manually? I tried recording a macro, but instead of just replacing the G for E it types...
  19. A

    Gant chart help for alignment

    Hi I have put together a spreadhseet for Gant chart and alignment, However it is not seeming to work proplery as the % is not showing as the right way. I have names which show the days off as 100% and days in as 0% Can anyone help if I post the sheet???
  20. B

    Excel VBA inconsistent errors when trying to copy and paste objects from Excel to Word

    Hello All, I have some VBA code that will sometimes run just fine and sometimes will give an error. I am getting very frustrated and in need of some help ... I have tried various things, but just cannot find a solution. First ... what I am trying to do ... I have an embedded Word document...

Some videos you may like

This Week's Hot Topics