chart

  1. C

    Bar-in-cell chart

    Hello, I want the chart to be reversed. That the next days have the longest bar and vice versa.
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. X

    Cumulative Monthly Report

    Hi I have a range of data that looks something like the attached image. The data is from an external database that I have cleaned up in Power Query (it wouldn't clean up in Power Pivot) and brought into Excel. I would like to produce a cumulative monthly report that total of requests that...
  8. V

    Chart series date misalignment depending on source data

    Hello, I'm having an issue trying to bring multiple data sources with date X-axis values into the same chart with a VBa macro. The chart "scales" to the first series added or whichever is set as the source data. When the other series' are added, I think they might be unwittingly "discretized"...
  9. MarkSELA

    Trouble deleting only freeform shapes in excel chart using VBA and not the chart.

    With help from Peltier.com I've put together a sub which shades under two excel scatter plots using freeform shapes and filling the shapes. The sub then copies the chart and the 2 associated shapes to be used in a word document. I would the sub to delete the shapes and leave the chart so that...
  10. M

    Chart picture vs camera tool - Which to use?

    Hello all! I have been reading posts here and online and i'm not sure which path to try. I have a Userform with many buttons that lead to various "Orderforms" - 1 per vendor. What my macro does is capture the info from each vendor onto 1 "Summary" Sheet and 1 "customer info" sheet. (I guess...
  11. Y

    Label name doesn't appear in vertical axis of the chart

    I have a two column table, column one name of countries column two a number field. Table has 230 rows. Number column is sorted I draw the chart and in Format axis|Axis options|Labels|Specify interval unit to 1 but some names like Italy doesn't appear in the chart. What shall I do to get Italy...
  12. M

    Line chart - multiple lines with gradient

    Hi! I'm looking to create a chart with multiple lines, each one representing a different day's worth of data. As I add more lines, I want the newer data to be shown in a different color as the older one, forming a gradient among the lines that makes it clear which data is more recent. This could...
  13. L

    Time based graph

    Hi, Is it possible to create a time based graph in Excel where I can plot a bookmakers odds against the Timestamp (Timevalid) on the axis and the odds on the y axis? I would like to define which Bookmakers to include in a filter for the graph (is this a pivot graph?) as well as which selection...
  14. O

    Help counting text value in pivot table

    Hello, i have a question for a practice interview test which is On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...
  15. Jyggalag

    Make a small percentage increase seem big in a chart - IDEAS?

    Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...
  16. B

    OFFSET formula to create a dynamic chart based on 2 distinct ranges

    Hello, I am trying to create a dynamic chart with the OFFSET function to display 2 data ranges of a factory production planning. Below is an image of the planning sheet, where the first row indicates the date, the second row shows the forecast, and row 13 indicates the processed workload. Based...
  17. Jyggalag

    Color the area inbetween two lines in a chart/graph?

    Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...
  18. F

    Creating a dynamic chart range over a table with cells made blank via a formula

    Hi, I am working on Excel 2013. I am currently struggling to present my vertical column organised dataset on a bar chart. I have formulae that return different datasets depending on variables set by the user elsewhere, and this should feed into a bar chart with a varying number of categories...
  19. A

    Need help in replicating chart

    Here is a simple chart (two periods, one variable per period, three groups): Can it be replicated in Excel? I guess I have to make a scatter plot, but only with one axis? I'm confused. Underlying data can be downloaded here.
  20. C

    How do you create a partially stacked area chart?

    I have a data set for which I'm trying to create a partially stacked area chart. One row of data has only positive numbers while the other three rows of data have only negative numbers. I'm trying to figure out how to include all of this data in the same area chart, but only stack the data...

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