Super User Stack Exchange
Super User Stack Exchange

Questions tagged [bar-chart]

10 questions
2
votes
1 answer

Creating Bar Chart with Start time and End time

I want to create a bar chart from the following data which will look like the attached picture. The data will have a start time, end time, and a number value. Sample Data: Bar Graph: Basically, I want to create a Bar Chart where in the X-axis I…
Abdullah Al Mamun
  • 23
  • 5
2
votes
3 answers

How to Format Excel Bar Chart Date Axis Tied to Pivot

In the barchart below I want to format the X-axis to be "7/21". You can see that I've formatted in my pivot chart but that didn't help. Then in the Format Axis panel at the bottom under the Number section the formatting options for Date are there…
sisdog
  • 211
  • 1
  • 2
  • 6
1
vote
1 answer

Force bar chart to show missing years within 10-year range (system year + 9)

I have a table in Excel 2016: YEAR_ AMOUNT ---------- ---------- 2024 100 2025 200 2025 300 2026 400 2027 500 2028 600 2028 700 2028 …
User1974
  • 137
  • 1
  • 18
1
vote
1 answer

Stacked bar chart to show asset maintenance types by year

I have a table of roads by year. The NEXT_ACTIVITY column categorizes the roads by the theoretical maintenance activity that the roads fall into. YEAR COUNT/TOTAL ROAD_COUNT NEXT_ACTIVITY ---- ---------- ----------- …
User1974
  • 137
  • 1
  • 18
1
vote
1 answer

Bar chart reduce number of labels by creating Others

pretty new in excel and I'm currently working on a pivot table and want to create a bar chart. I have around 15 row labels and 2 columns- row labels and percentages that looks something like this: apples 0.1% apricots 0.28% guava …
hjun
  • 11
  • 2
0
votes
0 answers

Pivot bar chart legend order

I have a PivotChart that is a stacked bar chart in Excel 2016. I want to control how the Ward numbers are displayed in the chart. I want to keep the PivotTable Ward number columns in alphabetical order. And I want to change the Ward number legend…
User1974
  • 137
  • 1
  • 18
0
votes
1 answer

How can I turn this list of values into a stacked (and combined?) bar chart where every value is shown per day?

I have a list of values with an amount and a date. I would like to display it like a stacked (?) bar chart where each value is marked with its own box, and then displayed on the corresponding day – adding up to the total for each day. I understand…
Anders Carlén
  • 3
  • 2
0
votes
1 answer

Barchart for data in Excel

I have the data in the below table in excel and I want to display it in a bar chart where each row will be a bar but each two rows will be two bars sticked together representing Gas and Electric, so for example the first two adjacent bars will be…
Tak
  • 481
  • 2
  • 5
  • 20
0
votes
1 answer

Format series of excel pivot chart based on series title

I have a non-stacked pivot bar chart that is showing two values (Sum of Planned Hours & Sum of Actual Hours) for a number of Series. What I want to achieve is a formatting rule that if all the bars for Planned Hours for each series are shown in…
dnaylor93
  • 11
  • 3
0
votes
1 answer

Add Bar chart in MS Excel for start time and end time

Hi All I want to create sort of bar chart in excel which shows activities happening in a machine over the time. Machine StateCode StateName StartTime EndTime XY 1000 SHIFT_START 29/07/2019 16:30 29/07/2019 16:31 XY …
Waqas
  • 101