Questions tagged [bar-chart]
12 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…
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
- 221
1
vote
1 answer
MS Excel: How to create a modified stacked bar chart for consumption data, with roll-over?
I am trying to create a visual representation of Service Hours for a customer.
The customer contracts with us for 1+ years. When they purchase a service package, they buy a number of hours that they can "spend" to work with our Professional…
Corey
- 11
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
- 185
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
- 185
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
0
votes
1 answer
Excel Chart: Can't increase plot area
I was able to work with a template that more or less accomplishes what I'm looking for, however I've hit a wall.
Specifically, the maximum vertical height of the plot. If I adjust the vertical height to accommodate an additional item above the…
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
- 185
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…
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
- 591
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
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