chart

  1. D

    Create Chart

    How do I go about creating a vba macro that reads data from a sheet in order to create a chart? in the sheet below my test data is found in columns a,b with details in rows 2-8. However in the real data my rows will be much more. Add a new sheet to insert the chart. Thanks Date Color...
  2. T

    How to create a candlestick chart from a Pivot table?

    Is it possible to create candlestick chart from a PivotTable? I just can't find out how to arrange the data to be able to create a candlestick chart. I only get "You can't create this chart type inside a PivotTable". I have the PivotTable connected to a database connection and it would be...
  3. P

    Turning OFF the visibility of a horizontal (category) axis labels if certain conditions apply

    I'm having trouble with my chart creation macro and would greatly appreciate any help. I want it to import data from the sourcesheet and create a chart for each row (macro is working for it); however, I'm trying to make my macro to edit the charts and not include a specific year if it has...
  4. mohsinbipu

    Wagon wheel graph in Excel

    Dear Excel expert, Can you please kindly help me to find out a way to draw a graph like this
  5. F

    Using table name in a chart

    I am copying a chart from tab 2023 to tab 2024 in my workbook. When I do this the table in tab 2024 references the data in tab 2023. Is there a way to get the location of the data to change with the tab name.
  6. B

    VBA to add Multiple Charts on One Worksheet

    Hi all, I am wanting to use VBA to insert multiple charts into one worksheet in specific spaces. I have a chart template created already as the same chart will be used for each. Here is a photo to help explain what I'm wanting to do. I want to use the data in each row to create a bar chart...
  7. H

    Constructing a custom Y axis for a chart

    This might be a simple question but I am looking to make a bar graph using what is in the data picture The scale I am looking to use is the second picture - with 1 being completely false and 7 being completely true. In the graph I am looking to have the graph show completely false at the bottom...
  8. M

    Charting assistance request

    I have the below data, where column 1 is a date, column 2 is a location # of computers, and Column 3 is a location. The order of the columns doesn't matter. I would like to chart the location and number of computers at that location over time, showing a shift from one location to another...
  9. M

    Heide column chart with zero values in Excel

    Good morning, everyone! I am trying to create a dynamic chart in Excel. However, I want to hide the columns in Bar chart with contains zeros because it looks too much crowdy. I used the zero filters, but it hides for me the whole column. my problem that each category has 4 bar chart I just want...
  10. B

    Graph/chart options for 5 years of monthly data points for 40 departments

    Hi all, I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year...
  11. A

    Update each bar color based on values in column A

    Hi All, I would like to fill colours of each bar based on values available in column A using VBA. Please see below image. I can simply fill the colour manually, but i would like to do using VBA because I am producing same kind of chart where more bars adds or removes so colours on bar graphs...
  12. D

    VBA to set absolute position of chart DataLabel

    I have an Excel scatterplot with a number of 2-point series. I am trying to set the position of each DataLabel in VBA, but its behavior is unpredictable. Here is the result, with each label text showing the (.Left, .Top) value that was set: I would expect every label with .Left = 100 to be...
  13. J

    Move a chart from Sheet 1 to Sheet 2

    I created a complex chart on Sheet 1 but need to move it to a clean sheet 2. How do I do it? jgb
  14. A

    Macro switches rows/columns in chart when only 2 data points

    My macro builds a bar chart from data in A5:B and F5:F. The horizontal labels are in A and the values to be charted against the vertical column are in B and F. My code worked fine until a co-worker's dataset only had 2 data points (so the chart covered A5:B6 and F5:F6) and then things flipped...
  15. C

    Bar-in-cell chart

    Hello, I want the chart to be reversed. That the next days have the longest bar and vice versa.
  16. B

    Conditional formatting the number format of a chart

    Hi all, I'm trying to find a solution for a chart in PowerPoint, but I assume that if there's a way to do it in Excel it would also be applicable to my query. I'm trying to achieve the following. I have a column chart and I want to force it to show only the values <3% with 1 decimal place, and...
  17. Y

    Chart with VBA

    Hi Experts, I am trying to create an automated mind map chart according to the table. So basically group one would be on the left, if IN is true then group 2 "feeds" group 1, if OUT is true then group one feeds group 2, if both are true then they feed each other. Group 2 always feeds group 3...
  18. Worf

    Organization chart with VBA – Part 3

    This is a continuation of the project mentioned below. To produce the chart, run the main routine. The information on each box is now presented in two different colors. These colors come from the corresponding cells at the source table. For more detailed explanations, refer to the previous...
  19. S

    Show Items With No Data Not Working the Same Since Nov 2022?

    I have a spreadsheet that I haven't refreshed since the middle of November 2022. When I refresh the data today, the chart shows every month instead of only the filtered month! Has something changed in excel since November 2022? This used to work, but now doesn't, and all I did was RMB...
  20. V

    39 sponges in a tray...

    Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited. I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the...

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